vendredi 6 juin 2008

Characters and Apostrophes

We have an universe in French language, objects and classes in french like:

Données and Date de l'implementation.

I opened my designer and the universe opened with these descriptions:

Donnies and Date de l implementation

I exported and got the following error:

Problem Error: "[Microsoft] [ODBC SQL Server Driver] [SQL Server] Statement(s) could not be prepared. Contact your administrator or database supplier for more information (Error: WIS 10901)" when running a report in WebIntelligence
Resolution *****CONFIGURATION******
WebIntelligence 6.1x
SQL Server 2000

***********SYMPTOMS*******
When running a report in WebIntelligence, the following error message appears:

'[Microsoft] [ODBC SQL Server Driver] [SQL Server] Statement(s) could not be prepared. Contact your administrator or database supplier for more information (Error: WIS 10901)"

**********CAUSE**************
The report is created from a Universe that has an apostrophe in the Class and/or object names.

**********RESOLUTION******
Remove the apostrophe from the Class and/or object names.



*************MY RESOLUTION************
Restore repository's backup to get the old universe. It worked

Aucun commentaire: