error:RQP-DEF-0177 - An error occurred while performing operation 'sqlPrepareWit

[numbsyd]

when i run report from cognos connection, i get the following error, couldn't figureout what's wrong, do any of you have ideas?? i heard it could be datasource connection error, need clarification from more novice guys, please help!

RQP-DEF-0177

       An error occurred while performing operation 'sqlPrepareWithOptions' status='-201'.

      Details 

UDA-SQL-0107 A general exception has occurred during the operation "open cursor". UDA-SQL-0445 The Sybase server: TESTL returned the following message: "Cognos_P_FlexPlanType_VW not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).". UDA-SQL-0196 The table or view "Cognos_P_FlexPlanType_VW" was not found in the dictionary. RSV-SRV-0042 Trace back: .....blah! blah!

[cognosjon]

hi,

its complaining that the table or view 'Cognos_P_FlexPlanType_VW' does not exist. Is this a table that you have within your framework/data warehouse that may have changed?



sorry edited my comment as after reading it the first time it sounded like I was being an £!"$"! hope you didn't see it that way, no offence intended.

[numbsyd]

quote author=cognosjon link=topic=8540.msg27688#msg27688 date=1261405197]
hi,

its complaining that the table or view 'Cognos_P_FlexPlanType_VW' does not exist. Is this a table that you have within your framework/data warehouse that may have changed?



sorry edited my comment as after reading it the first time it sounded like I was being an £!"$"! hope you didn't see it that way, no offence intended.





[/quote]
no worries!

unfortunately the view exists, as i said, would it be a data source connection error?? we have two DSC(data source connections) for dev team and QA team respectively, the same report runs well with Dev DSC and doesn't run with QA DSC.

[cognosjon]

can we assume that you have been able to create and test successfully a connection to the datasources on both servers Dev and QA