Business Analytics with SQL2005 - Case Sensitive

jigsaw

When the Configurator runs in Nav 4.0 SP3 on SQL Server 2005 the SSIS package fails. The issue appears to related to Case Sensitivity.
In simple terms

- my SQL Server 2005 is set to be Case Sensitive and Accent Sensitive (CS_AS)
- when I run "Start the Configurator" the wizard runs the the "BA for MBS Navision" is being created with the Servers collation CS_AS
- the SSIS package fails when it tries to validate/query the table Information_Schema.Tables as the real name in the database is INFORMATION_SCHEMA.TABLES (Notice difference in case)
(I can tell what the error is by manually running the SSIS script)

I am not in a situation where I can change the servers collation to be case insensitive.

I can't see how I can change the way the package is built as the details appear to be encapsulated in the Configurator.exe file.

kine

You cannot change the server collation, but are you able to change the DB collation?

jigsaw

The Collation of the NAV DB does not matter.

The BA for MBS Navision" DB is dropped and re-created each time, and inherits the Servers Collation.

jigsaw

This issue is due to a bug in the BA Configurator. The only quick fix is to re-install the SQL Server2005 as case in-sensitive which is not always an available option.
MS are looking into the issue further.

kine

Hmmm... it seems like the testers in MS are not creative enough to test all possibilities... 8)

Luciano

Hi,

I'm running NAV 4.0 SP3 SQL2005 and I've got the same error. The SSIS package fails. The message in the event viewer is "Origin: SQLISPackage, ID 12291".
I reinstalled SQL as case insensitive but I've got the same error. Do you think that I have to check other parameters?
Thanks!

Luciano

To build cubes in Italian release of NAV 4.0/SP3 (Build 23305) SQL 2005 the Windows international options in the control panel must be set to English, otherwise the Configurator fails because of dates format.