Error on Refreshing webi report

[former_member402770]

Hi Experts

We are facing an error at Webi Level. Could you please help. We found Composite database granted permission for view, universe working fine individual columns are working as expected but below error throws at webi level.

Composite driver used is 7.0, IDT installed is 4.2. The view is under one catalog under single schema.

Error Message:

The following database error occurred: Invalid table 'V_VINTAGE'. On line 5, column 2. [parser-2906435]. For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901) (Error: INF ).

Appreciate your quick reply.

Regards,

Dinya

[amitrathi239]

can you post the sql.it seems some snytax issue with view sql.. have you pared the view sql?

[former_member536749]

Hi,

This is the SAP Note you were referring to: 2054721

Resolution

The error "WIS 10901" and / or "IES 10901", which is seen when refreshing or scheduling Web Intelligence reports, is a result of the Web Intelligence Processing Server indicating that the reporting database has returned a warning or error message.

The additional text and information returned with this error should provide a general idea on the issue. Frequent causes are:

• Reporting database drivers not loaded or found
• An error returned by the reporting database indicating a connection or other system issue
• Network connectivity between the BI server and the reporting database

As Amit mentioned; do post MDX statement of the query in WebI. Also, did you tried the same analysis in IDT query panel?.

Thanks,

Jothi

[former_member402770]

Hi Amit,

Iam getting the same error even when i parse the sql. Iam also not able to map the qualifierit is disable where owner is selected with delimit option checked. Could you explain me to understand about the Table Qualifier\Owner selection with delimit option.

Thanks,

Dinya

[jyothirmayee_s]

Hi,

I think you have selected tables to change Qualifier/Owner by default table name.

In the "Change Qualifier/Owner" dialog box, click the browse button in the Qualifier field. check If the qualifier name is delimited by default, select or unselect Delimit.

for more details check these blogs:

https://www.tutorialspoint.com/sap_idt/sap_idt_qualifiers_and_owners.htm

https://stefanchristen.wordpress.com/tag/information-design-tool/

Thanks,

Jothi

[amitrathi239]

it seems issue is not related with table owner/qualifier. run the same sql at database level and see. most probaly issue with the sql only.

[former_member402770]

Hi Jothi,

IDT Query panel throws same error "Invalid Table" also at webi level too.

In DB the same sql works fine

Thanks,

Dinya

[former_member402770]

Hi Amit,

IDT Query panel throws same error "Invalid Table" also at webi level too.

In DB the same sql works fine

Thanks,

Dinya

[former_member402770]

any hint could be composite driver issue we are using 7.0 Cisco ODBC driver?

[jyothirmayee_s]

Hi,

Can you just query on this table and see that gives an error?.

Try refreshing Data Foundation and check the cardinalities on this particular table?. Also, Business Layer if that table objects are available.

Thanks,

Jothi