Problemas OBI con despliegue de datos enSYDBASE IQ

Ver el tema anterior Ver el tema siguiente Ir abajo

Problemas OBI con despliegue de datos enSYDBASE IQ

Mensaje  ptoledoo el Miér 24 Oct 2012, 22:17

estimados, como siempre hace unos días me informan que tengo que hacerme cargo de la Administración de OBI Montado en una Maquina Virtual con Windows Server y con conexion a SYBASE IQ y a los 2 días me traen un problema, diciéndome que al querer revisar los datos de las tablas, estas no se despliegan y me adjuntan en siguente log, llamado NQSAdminTool.log

esta información les dice algo??, si me pueden ayudar seria ideal, yo seguiré buscando en doctor google, y si encuentro la solución, la agregare al foro
Gracias

Código:


[2012-10-18T20:01:35.000+00:00] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 9a0] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled.  This can lead to inconsistencies.
[2012-10-23T14:26:03.000+00:00] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 3bc] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled.  This can lead to inconsistencies.
[2012-10-23T14:30:19.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 16001] ODBC error state: 28000 code: -103 message: [Sybase][ODBC Driver][SQL Anywhere]Invalid user ID or password.
[2012-10-23T14:30:23.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 16001] ODBC error state: 28000 code: -103 message: [Sybase][ODBC Driver][SQL Anywhere]Invalid user ID or password.
[2012-10-23T14:30:38.000+00:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 3bc]  [16020] Metadata Database Type: ODBC 2.0 [[
Data Source Name: Produccion_IQ
Data Source Type: Sybase IQ 11.00.0000
]]
[2012-10-23T14:30:38.000+00:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 3bc] Data Source Name: Produccion_IQ [[
Client Driver Version 11.00.0001
]]
[2012-10-23T14:46:26.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 16001] ODBC error state: 28000 code: -103 message: [Sybase][ODBC Driver][SQL Anywhere]Invalid user ID or password.
[2012-10-23T14:46:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 16001] ODBC error state: 28000 code: -103 message: [Sybase][ODBC Driver][SQL Anywhere]Invalid user ID or password.
[2012-10-23T14:53:33.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: adc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-23T15:10:36.000+00:00] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 1514] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled.  This can lead to inconsistencies.
[2012-10-23T15:11:16.000+00:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 1514]  [16020] Metadata Database Type: Unknown [[
Data Source Name: ORCL
Data Source Type: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Produc
]]
[2012-10-23T15:16:27.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 16001] ODBC error state: 28000 code: -103 message: [Sybase][ODBC Driver][SQL Anywhere]Invalid user ID or password.

[2012-10-23T15:18:20.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: adc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]

[2012-10-23T15:49:30.000+00:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 3bc]  [16020] Metadata Database Type: ODBC 2.0 [[
Data Source Name: Produccion_IQ
Data Source Type: Sybase IQ 11.00.0000
]]
[2012-10-23T15:49:30.000+00:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 3bc] Data Source Name: Produccion_IQ [[
Client Driver Version 11.00.0001
]]
[2012-10-23T15:49:34.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: adc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-23T15:49:34.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: adc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-23T16:04:24.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 16001] ODBC error state: 28000 code: -103 message: [Sybase][ODBC Driver][SQL Anywhere]Invalid user ID or password.
<"ProdIQ".."dbo"."ix_consultant_affected_columns"."master_id">: Not defined.
[2012-10-23T16:23:35.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."ix_consultant_index"."master_id">: Not defined.
[2012-10-23T16:23:35.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."ix_consultant_ixcol"."master_id">: Not defined.
[2012-10-23T16:23:35.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."ix_consultant_log"."master_id">: Not defined.
[2012-10-23T16:23:36.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."ix_consultant_query_index"."master_id">: Not defined.
[2012-10-23T16:23:36.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."ix_consultant_query_phase"."master_id">: Not defined.
[2012-10-23T16:23:36.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."ix_consultant_query_text"."master_id">: Not defined.
[2012-10-23T16:23:36.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."sa_diagnostic_blocking"."logging_session_id">: Not defined.
[2012-10-23T16:23:36.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."sa_diagnostic_blocking"."logging_session_id">: Not defined.
[2012-10-23T16:23:36.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."sa_diagnostic_cursor"."logging_session_id">: Not defined.
[2012-10-23T16:23:36.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."sa_diagnostic_hostvariable"."logging_session_id">: Not defined.

[2012-10-23T16:23:36.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."sa_diagnostic_optrewrite"."logging_session_id">: Not defined.
[2012-10-23T16:23:36.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."sa_diagnostic_query"."logging_session_id">: Not defined.
[2012-10-23T16:23:36.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."sa_diagnostic_request"."logging_session_id">: Not defined.
[2012-10-23T16:23:36.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."sa_diagnostic_request"."logging_session_id">: Not defined.
[2012-10-23T16:23:36.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."sa_diagnostic_request"."logging_session_id">: Not defined.
[2012-10-23T16:23:36.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."sa_diagnostic_request"."logging_session_id">: Not defined.
[2012-10-23T16:25:33.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 16015] SQL statement execution failed. [[
[nQSError: 16001] ODBC error state: 42000 code: -121 message: [Sybase][ODBC Driver][Sybase IQ]Permission denied: you do not have permission to select from "TmpReg".
]]
[2012-10-23T16:25:44.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 16015] SQL statement execution failed. [[
[nQSError: 16001] ODBC error state: 42000 code: -121 message: [Sybase][ODBC Driver][Sybase IQ]Permission denied: you do not have permission to select from "TmpReg".
]]
[2012-10-23T16:25:46.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: adc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 42000 code: -121 message: [Sybase][ODBC Driver][Sybase IQ]Permission denied: you do not have permission to select from "TmpReg".
]]
[2012-10-23T16:25:46.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: adc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 42000 code: -121 message: [Sybase][ODBC Driver][Sybase IQ]Permission denied: you do not have permission to select from "TmpReg".
]]
[2012-10-23T16:25:46.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 42000 code: -121 message: [Sybase][ODBC Driver][Sybase IQ]Permission denied: you do not have permission to select from "TmpReg".
]]
[2012-10-23T16:41:51.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: adc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-23T16:41:51.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: adc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-23T16:41:51.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-23T16:42:13.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: adc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-23T16:42:13.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: adc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-23T16:42:13.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-23T18:09:41.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: adc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-23T18:09:41.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: adc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-23T18:09:41.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-23T18:09:44.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: adc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-23T18:09:44.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: adc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-23T18:09:44.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."ix_consultant_affected_columns"."master_id">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."ix_consultant_index"."master_id">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."ix_consultant_ixcol"."master_id">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."ix_consultant_log"."master_id">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."ix_consultant_query_index"."master_id">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."ix_consultant_query_phase"."master_id">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."ix_consultant_query_text"."master_id">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."sa_diagnostic_blocking"."logging_session_id">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."sa_diagnostic_blocking"."logging_session_id">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."sa_diagnostic_cursor"."logging_session_id">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."sa_diagnostic_hostvariable"."logging_session_id">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."sa_diagnostic_optblock"."logging_session_id">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."sa_diagnostic_optjoinstrategy"."logging_session_id">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."sa_diagnostic_optorder"."logging_session_id">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."sa_diagnostic_optorder"."logging_session_id">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."sa_diagnostic_optquantifier"."logging_session_id">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."sa_diagnostic_optrewrite"."logging_session_id">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."sa_diagnostic_query"."logging_session_id">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."sa_diagnostic_request"."logging_session_id">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."sa_diagnostic_request"."logging_session_id">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."sa_diagnostic_request"."logging_session_id">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."dbo"."sa_diagnostic_request"."logging_session_id">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."DMCONTA"."DMMUN_EJECUCION"."EJERCICIO">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."DMCONTA"."DMMUN_EJECUCION"."EJERCICIO">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."DMCONTA"."DMMUN_EJECUCION"."EJERCICIO">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."DMCONTA"."DMMUN_EJECUCION"."MONEDA">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."DMCONTA"."DMMUN_PATRIMONIO"."EJERCICIO">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."DMCONTA"."DMMUN_PATRIMONIO"."EJERCICIO">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."DMCONTA"."DMMUN_PATRIMONIO"."EJERCICIO">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."DMCONTA"."DMMUN_PATRIMONIO"."MONEDA">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."DMCONTA"."DMPUB_EJECUCION"."EJERCICIO">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."DMCONTA"."DMPUB_EJECUCION"."EJERCICIO">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."DMCONTA"."DMPUB_EJECUCION"."EJERCICIO">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."DMCONTA"."DMPUB_EJECUCION"."MONEDA">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."DMCONTA"."DMPUB_PATRIMONIO"."EJERCICIO">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."DMCONTA"."DMPUB_PATRIMONIO"."EJERCICIO">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."DMCONTA"."DMPUB_PATRIMONIO"."EJERCICIO">: Not defined.
[2012-10-23T18:11:28.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 28006] Near Line 3, <"ProdIQ".."DMCONTA"."DMPUB_PATRIMONIO"."MONEDA">: Not defined.
[2012-10-23T18:13:11.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: adc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-23T18:13:11.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: adc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-23T18:13:11.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-23T18:13:14.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: adc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-23T18:13:14.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: adc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-23T18:13:14.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-23T18:37:07.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: adc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-23T18:37:07.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: adc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-23T18:37:07.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-23T19:01:54.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: adc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-23T19:01:54.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: adc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-23T19:01:54.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-23T20:28:18.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: adc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-23T20:28:18.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: adc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-23T20:28:18.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 3bc]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-23T21:02:05.000+00:00] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 17b4] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled.  This can lead to inconsistencies.
[2012-10-23T21:02:59.000+00:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 17b4]  [16020] Metadata Database Type: ODBC 2.0 [[
Data Source Name: Produccion_IQ
Data Source Type: Sybase IQ 11.00.0000
]]
[2012-10-23T21:02:59.000+00:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 17b4] Data Source Name: Produccion_IQ [[
Client Driver Version 11.00.0001
]]
[2012-10-24T14:02:30.000+00:00] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 600] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled.  This can lead to inconsistencies.
[2012-10-24T14:03:15.000+00:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 600]  [16020] Metadata Database Type: ODBC 2.0 [[
Data Source Name: Produccion_IQ
Data Source Type: Sybase IQ 11.00.0000
]]
[2012-10-24T14:03:15.000+00:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 600] Data Source Name: Produccion_IQ [[
Client Driver Version 11.00.0001
]]
[2012-10-24T14:05:53.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 860]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-24T14:05:53.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 860]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-24T14:05:53.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 600]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-24T14:53:33.000+00:00] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: d40] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled.  This can lead to inconsistencies.
[2012-10-24T15:02:35.000+00:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: d40]  [16020] Metadata Database Type: ODBC 2.0 [[
Data Source Name: GEACGR
Data Source Type: Sybase IQ 11.00.0000
]]
[2012-10-24T15:02:35.000+00:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: d40] Data Source Name: GEACGR [[
Client Driver Version 11.00.0001
]]
[2012-10-24T15:29:35.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: d94]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-24T15:29:35.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: d94]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-24T15:29:35.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: d40]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-24T18:02:13.000+00:00] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 764] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled.  This can lead to inconsistencies.
[2012-10-24T18:02:54.000+00:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 764]  [16020] Metadata Database Type: ODBC 2.0 [[
Data Source Name: GEACGR
Data Source Type: Sybase IQ 15.10.0000
]]
[2012-10-24T18:02:54.000+00:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 764] Data Source Name: GEACGR [[
Client Driver Version 12.00.0001
]]
[2012-10-24T18:03:43.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 764]  [nQSError: 16001] ODBC error state: S0002 code: -141 message: [Sybase][ODBC Driver][Sybase IQ]Table 'S_COLUMN' not found.
[2012-10-24T18:03:55.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 764]  [nQSError: 16001] ODBC error state: S0002 code: -141 message: [Sybase][ODBC Driver][Sybase IQ]Table 'S_COLUMN' not found.
[2012-10-24T18:03:58.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 764]  [nQSError: 16001] ODBC error state: S0002 code: -141 message: [Sybase][ODBC Driver][Sybase IQ]Table 'S_COLUMN' not found.
[2012-10-24T18:04:02.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 764]  [nQSError: 16001] ODBC error state: S0002 code: -141 message: [Sybase][ODBC Driver][Sybase IQ]Table 'S_COLUMN' not found.
[2012-10-24T18:05:00.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 930]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-24T18:05:00.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 930]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-24T18:05:00.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 764]  [nQSError: 16014] SQL statement preparation failed. [[
[nQSError: 16001] ODBC error state: 37000 code: -131 message: [Sybase][ODBC Driver][Sybase IQ]Syntax error near 'from' on line 1.
]]
[2012-10-24T18:36:18.000+00:00] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: df4] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled.  This can lead to inconsistencies.

ptoledoo

Cantidad de envíos : 2
Localización : Chile
Fecha de inscripción : 24/10/2012

Ver perfil de usuario

Volver arriba Ir abajo

SOLUCIONADO

Mensaje  ptoledoo el Jue 25 Oct 2012, 02:22

EL PROBLEMA SE GENERA CON LAS TABLAS QUE TIENE LA SIGUENTE ESTRUCTURA XXX_XXX EJ: TBL_PASO, PERO SI ESTA TABLA LA RENOMBRO O CREO OTRA CON EL NOMBRE TBLPASO, EL PROBLEMA SE SOLUCIONA..

Ahora lo que no se si hay algun parche para el obi 11.1.1 para solucionar ese problema con el resto de las tablas....

ptoledoo

Cantidad de envíos : 2
Localización : Chile
Fecha de inscripción : 24/10/2012

Ver perfil de usuario

Volver arriba Ir abajo

Ver el tema anterior Ver el tema siguiente Volver arriba

- Temas similares

 
Permisos de este foro:
No puedes responder a temas en este foro.