Hi,
My unix server has been migrated from a AIX 4.3.3.81 server to AIX 5L, and the database on this server has been migrated from oracle 8.1.7 to 9.2.0.4. The powerplay enterprise server hasn’t changed and is verision 6.5 and is running on the same server as the database.
the DSN hasn't changed, so i just copied the old .mdl files from the old server, but when i try generating a cube on the unix server i have this error :
30.05.05 17:07:20 4 0000149B Start processing data source 'query.iqd'.
30.05.05 17:07:20 4 0000149B Reading source data.
30.05.05 17:07:21 2 0000149B DMS-E-GENERAL, A general exception has occurred during operation 'attach database'.
30.05.05 17:07:21 2 0000149B ORA-03113: end-of-file on communication channel
30.05.05 17:07:21 2 0000149B
30.05.05 17:07:21 4 0000149B End processing 0 records from data source 'query.iqd'.
30.05.05 17:07:21 4 0000149B Timing, READ DATA SOURCE,00:00:01
30.05.05 17:07:21 4 0000149B End cube update.
30.05.05 17:07:21 4 0000149B Timing, TOTAL TIME (CREATE CUBE),00:00:01
30.05.05 17:07:21 2 0000149B (TR0118) Transformer Server can't read the database [MY_DSN] defined in /powerplay/iqd/query.iqd. [->OK]
rsserver -mMyOldModel.mdl -c
the environment variables for the database are :
> echo $LD_LIBRARY_PATH :/logi/ora920/lib
> echo $ORACLE_HOME /logi/ora920
> echo $TNS_ADMIN /appli/sqlnet/comp/param
There’s no problem with the database : MY_DSN is correctly declared in the tnsnames.ora file and i can access the database running this command on the server
>sqlplus user/pwd@MY_DSN
does rsserver need some other environment variable to read the database?
I’ve also encountered some « weird » behaviour with powerplay server : when the process server ppserver is started by « root » user, the server cubes can’t be opened by the windows powerplay client, and i get a timeout error message. I have stopped the process and re-started it with my application user, and only then can i open the cubes from the client . Has anyone got any idea ?
My unix server has been migrated from a AIX 4.3.3.81 server to AIX 5L, and the database on this server has been migrated from oracle 8.1.7 to 9.2.0.4. The powerplay enterprise server hasn’t changed and is verision 6.5 and is running on the same server as the database.
the DSN hasn't changed, so i just copied the old .mdl files from the old server, but when i try generating a cube on the unix server i have this error :
30.05.05 17:07:20 4 0000149B Start processing data source 'query.iqd'.
30.05.05 17:07:20 4 0000149B Reading source data.
30.05.05 17:07:21 2 0000149B DMS-E-GENERAL, A general exception has occurred during operation 'attach database'.
30.05.05 17:07:21 2 0000149B ORA-03113: end-of-file on communication channel
30.05.05 17:07:21 2 0000149B
30.05.05 17:07:21 4 0000149B End processing 0 records from data source 'query.iqd'.
30.05.05 17:07:21 4 0000149B Timing, READ DATA SOURCE,00:00:01
30.05.05 17:07:21 4 0000149B End cube update.
30.05.05 17:07:21 4 0000149B Timing, TOTAL TIME (CREATE CUBE),00:00:01
30.05.05 17:07:21 2 0000149B (TR0118) Transformer Server can't read the database [MY_DSN] defined in /powerplay/iqd/query.iqd. [->OK]
rsserver -mMyOldModel.mdl -c
the environment variables for the database are :
> echo $LD_LIBRARY_PATH :/logi/ora920/lib
> echo $ORACLE_HOME /logi/ora920
> echo $TNS_ADMIN /appli/sqlnet/comp/param
There’s no problem with the database : MY_DSN is correctly declared in the tnsnames.ora file and i can access the database running this command on the server
>sqlplus user/pwd@MY_DSN
does rsserver need some other environment variable to read the database?
I’ve also encountered some « weird » behaviour with powerplay server : when the process server ppserver is started by « root » user, the server cubes can’t be opened by the windows powerplay client, and i get a timeout error message. I have stopped the process and re-started it with my application user, and only then can i open the cubes from the client . Has anyone got any idea ?