Business Analytics with SQL2005 - Case Sensitive

jigsaw
jigsaw Member Posts: 7
edited 2007-02-02 in NAV/Navision Classic Client
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.

Comments

  • kine
    kine Member Posts: 12,562
    You cannot change the server collation, but are you able to change the DB collation?
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • jigsaw
    jigsaw Member Posts: 7
    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
    jigsaw Member Posts: 7
    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
    kine Member Posts: 12,562
    Hmmm... it seems like the testers in MS are not creative enough to test all possibilities... 8)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Luciano
    Luciano Member Posts: 2
    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
    Luciano Member Posts: 2
    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.

Categories