Home » Fusion Middleware & Colab Suite » Business Intelligence » Odbc driver returned an error (SQLExecDirectW (OBIEE, Windows Xp.)
Odbc driver returned an error (SQLExecDirectW [message #445424] Mon, 01 March 2010 14:42
SatishkGoud
Messages: 6
Registered: March 2010
Location: USA
Junior Member
Hi Everyone
Had anyone came across this error on OBIEE Dashboard....plz help...

View Display Error
Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 17001] Oracle Error code: 1480, message: ORA-01480: trailing null missing from STR bind value at OCI call OCIStmtExecute: select T905625.ENRL_CAP as c1, T905625.RSRV_CAP_NBR as c2, T905625.START_DT as c3, T905924.DESCR as c4, T905635.ENRL_TOT as c5, T905625.CRSE_ID as c6, T905625.CRSE_OFFER_NBR as c7, T905625.STRM as c8, T905625.SESSION_CODE as c9, T905625.CLASS_SECTION as c10 from SYSADM.PS_CLASS_RSRV_CAP T905625, SYSADM.PS_CLASS_RSRV_GRP T905635, SYSADM.PS_RQ_GRP_ENR_VW T905924 where ( T905625.SESSION_CODE = T905635.SESSION_CODE and T905625.STRM = T905635.STRM and T905625.CRSE_ID = T905635.CRSE_ID and T905625.CRSE_OFFER_NBR = T905635.CRSE_OFFER_NBR and T905625.CLASS_SECTION = T905635.CLASS_SECTION and T905625.RSRV_CAP_NBR = T905635.RSRV_CAP_NBR and T905625.RQRMNT_GROUP = T905924.RQRMNT_GROUP and (T905625.CRSE_ID = :PARAM1 and T905625.CRSE_OFFER_NBR = :PARAM2 and T905625.STRM = :PARAM3 and T905625.SESSION_CODE = :PARAM4 and T905625.CLASS_SECTION = :PARAM5 or T905625.CRSE_ID = :PARAM6 and T905625.CRSE_OFFER_NBR = :PARAM7 and T905625.STRM = :PARAM8 and T905625.SESSION_CODE = :PARAM9 and T905625.CLASS_SECTION = :PARAM10 or T905625.CRSE_ID = :PARAM11 and T905625.CRSE_OFFER_NBR = :PARAM12 and T905625.STRM = :PARAM13 and T905625.SESSION_CODE = :PARAM14 and T905625.CLASS_SECTION = :PARAM15 or T905625.CRSE_ID = :PARAM16 and T905625.CRSE_OFFER_NBR = :PARAM17 and T905625.STRM = :PARAM18 and T905625.SESSION_CODE = :PARAM19 and T905625.CLASS_SECTION = :PARAM20) ) order by c6, c7, c8, c9, c10. [nQSError: 17011] SQL statement execution failed. (HY000)
SQL Issued: SELECT Class."Subject Code" saw_0, Class."Catalog Number" saw_1, Class."Class Section" saw_2, Class."Class Type" saw_3, "Reservation Capacity"."Enrollment Capacity" saw_4, "Reservation Capacity"."Reservation Capacity Number" saw_5, "Reservation Capacity"."Start Date" saw_6, "Reservation Capacity"."Requirement Group Description" saw_7, "Reservation Capacity"."Enrollment Total" saw_8 FROM "CSW - LIVE - Class Enrollment" WHERE (Class."Term Description" = 'Fall 2010') AND (Class."Class Type" = 'E') ORDER BY saw_0, saw_1, saw_2, saw_3, saw_4, saw_5, saw_6, saw_7, saw_8


Thank YOu
Satish


Previous Topic: BI don't see ODBC
Next Topic: BI First Launch
Goto Forum:
  


Current Time: Thu Mar 28 17:53:33 CDT 2024