csEX Error

[Former Member]

Team - I am able to run all the reports without any issue. When my user is running the report against "BOEXI40-Audit-MySQL.unx"... getting this error. Any suggestions from coming out from this issue.

Looking forward to hear from you -

[Former Member · Accepted solution]

The Error is caused by missing -Dbusinessobjects.connectivity.directory Property in whatever APS hosting WEBI DSL Service to resolve this copy the below link

"-Dbusinessobjects.connectivity.directory=E:\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer"

If APS is not Split

1. Log into CMC
2. Go to Servers
3. Stop and Disable AdaptiveProcessingServer
4. Right click APS
5. Paste the above Property at the end of your command line as shown below
6. Start and Enable your APS

If APS is split

1. in CMC locate the APS Host WebIDSLBridge
2. Repeat above steps of adding the missing property

All the Best

[sarah_klobe · Accepted solution]

This fixed our issue with our 4.1 SP4, Patch 5 upgrade. Thank you for the information!

[brian_wadell2 · Accepted solution]

This worked for us using 4.1 SP5 Patch 3 as well.

Thank you!!

[Former Member]

HI

We have also encountered this problem after upgrading from BO 4.0 SP5 (I think) to BO 4.1 SP4.

Environment Windows Server 2008 R2 Enterprise 64bit, Apache Tomcat/7.0.32.

The WebI reports against UNX universes are failing with this scEX (Error: inf) error.

The problem occurrs with UNX universes against SQL Server 2008 R2 database. UNX universes against SSAS cubes seems to work.

I can however open, run and edit the failing reports in WebI Rich Client, but again saved reports will fail in WebI.

Regards

Stefan

[Former Member]

I also am seeing this error csEX (Error:INF) from a recent upgrade to BI 4.1 SP04 Patch 4, error happens both when refreshing and when going to schedule a job.

[Former Member]

Hi Srinivasan,

How many nodes you have for this environment? Is this the only environment you have? Have you splitted the APS as per the seizing document? Please test the reports with few services by tagging in to server group. Let us know your findings.

Regards,

Siva

[Former Member]

i am also getting same error in BI4.1 sp2

i have created report based ob oracle 11g it is working fine in 4.0 sp6 after updating 4.1sp2 patch it is thoroughgoing error and all reports are working fine which is developed in sap bi

[hans_segers]

Dear all,

You'll have this issue when running a query in Web Intelligence based on a unx after patching.

Create (or recreate the existing) an APS dedicated for DSL Bridge.

Hans

[Former Member]

Hi Hans,

I guess the DSL Bridge is dedicated to the BICS interface right ? When we recreate the APS for DSL Bridge how does it work for WEBI based on Unx universes that has a datasource of Oracle ? Just curious to understand it ..

Thanks

Preetham

[Former Member]

Hi Preetham,

DSL Bridge is responsible for BICS and for unx universes as well.

Please try to recreate the DSL Bridge APS, it will probably solve the issue.

Thanks and regards,

Rabeb

[Former Member]

Hi Rabeb,

Thanks for the inputs yes it worked after we recreated the DSL Bridge.

Regards

Preetham

[Former Member]

Hi,

I think it may be a compatible issue because there are two extensions .unx and .unv .if you generate universe through universe design tool then it is .unv or if you design through information tool that is Bo 4.0 then it is .unx file.if you already done it BO 4.0 then it is not connecting with database Or Repo of  MySQL.So,please check whether your MySQL is working well or not

[Former Member]

i dont know - able to access my sql server without any issue

[former_member188911]

try this https://service.sap.com/sap/support/notes/1641434

[Former Member]

Simone - the link is not working ... could you please help me out

[Former Member]

Hi Srini,

This is what mentioned in the link provided by Simone: -

Symptom

• "A database error occured. The database error text is: [Microsoft][ODBC SQL Server Driver][SQL Server] Statement(s) could not be prepared. (WIS 10901)" when creating Web Intelligence document from the Activity universe 
• "Parse Failed: Exception: DBD, [Microsoft][ODBC SQL Server Driver][SQL Server] Statement(s) could not be prepared. State: 42000” while parsing objects in Universe Designer

  Environment 

• BusinessObjects Enterprise XI 3.1 
• Microsoft SQL Server 2005 
• SQL Native Client 
• Activity universe

Reproducing the Issue

1. Install Microsoft SQL Server 2005. 
2. Set up two ODBC data sources for CMS and Audit database. 
3. Install BusinessObjects Enterprise XI 3.1. 
4. Launch Designer after installation. 
5. Click File > Import. 
6. Select Activity universe and click OK. 
7. Click File > Parameters. 
8. Ensure that "Audit Connection" is selected in the Connection. 
9. Click Edit in the Definition tab. 
10. Ensure that Data Source name (which is created by Step 2) is selected in the Data Source name. 
11. Click Test Connection. 
12. Ensure that "The Server is responding!" message is displayed. 
13. Click Cancel. 
14. Click Cancel in the Universe Parameters window. 
15. Click Tools > Check Integrity. 
16. Check Check All in the Integrity Check window and click OK. 
17. The following objects get error "Parse Failed: Exception: DBD, [Microsoft][ODBC SQL Server Driver][SQL Server] Statement(s) could not be prepared. State: 42000".

• Action YYYY-WW 
• Action YYYY-MM 
• Action Quarter 
• Action YearAction 
• Action YYYY-MM-DD 
• Session Start YearSession 
• Session Start YYYY-MM 
• Session Start YYYY-MM-DD

18. Logon to InfoView. 
19. View any of sample Web Intelligence document (e.g. User Activity per Session) using Activity universe. 
20. Click Refresh Data. 
21. The following error message appears.

  "A database error occured. The database error text is: [Microsoft][ODBC SQL Server Driver][SQL Server] Statement(s) could not be prepared (WIS 10901)"

Resolution

Create an new ODBC Data Source using SQL Native Client database driver and replace it.

1. Launch ODBC Data Source Administrator. 
2. Click System DSN. 
3. Click Add. 
4. Select "SQL Native Client" from list of database driver and click Finish. 
5. Enter Data Source Name (e.g. NewAudit) and Microsoft SQL Server 2005 Server Name and click Next. 
6. Enter SQL Server 2005 logon information and click Next. 
7. Select an existing Audit Database and click Next. 
8. Click Finish. 
9. Click Test Data Source. 
10. Launch Designer. 
11. Click File > Import. 
12. Select an existing Activity universe and click OK. 
13. Click File > Parameters. 
14. Click Edit in the Definition tab. 
15. Select above created data source name (e.g. NewAudit). 
16. Enter User name and password and click Test Connection. 
17. Ensure that "The Server is responding!" message is displayed. 
18. Click Next in the Login Parameters [2/4]. 
19. Leave as default and click Next in the Login Parameters [3/4]. 
20. Click Finish in the Login Parameters [4/4]. 
21. Click OK in the Universe Parameters window. 
22. Click Tools > Check Integrity. 
23. Check Check All in the Integrity Check window and click OK. 
24. Click File > Save As. 
25. Type file name and click Save. 
26. Click File > Export. 
27. Select folder and click OK.

Thanks,

Vivek

[Former Member]

thank you vivek - mine is sp bo bi4 n file is .unx and it is working for me . when my user is trying to run - who is getting csEX Error .

[jyothirmayee_s]

Hi,

What is the error?. Can you post it please?

Thanks,

Jothi

[Former Member]

[Former Member]

Hi,

when did u upgrade to BO 4.0  and what is the patch you currently install,i think you must set mysql audit option to no and check.

Thanks,

Ashok

[Former Member]

yup Mr.Ashok - SP05