p4 to oracle conversion error

[fv2008]

Hi all:

when I use service center 6.2 convert p4 to oracle 10.2.0,there has some error .

some table which has IR key ,for example cm3r will make mistakes.

Could anyone can help me?
================================================== =====

2496( 3240) 12/18/2007 10:39:04 RAD I Initiating a Conversion of cm3r
2496( 3240) 12/18/2007 10:39:04 RAD I Mapping tables cm3r
2496( 3240) 12/18/2007 10:39:05 RAD I Creating SQL Tables for cm3r
2496( 3240) 12/18/2007 10:39:05 RTE I File Copy: About to copy 17 records from 'cm3r' to 'TEMPcm3r'
2496( 3240) 12/18/2007 10:39:06 RTE I File Copy: Copying 17 records from cm3r. Completed 10
2496( 3240) 12/18/2007 10:39:06 RTE I File Copy: Successfully copied 17 records from 'cm3r' to 'TEMPcm3r'
2496( 3240) 12/18/2007 10:39:06 RAD I $L.bad.recs= 0
2496( 3240) 12/18/2007 10:39:06 RAD I $L.convert.flg = true
2496( 3240) 12/18/2007 10:39:06 RTE REGEN of file 'cm3r' is starting
2496( 3240) 12/18/2007 10:39:06 RTE sqlExec error: sqlcode=1403 message=ORA-01403: no data found
2496( 3240) 12/18/2007 10:39:06 RTE sqlExec error statement=read data from Lob
2496( 3240) 12/18/2007 10:39:06 RTE sqlExec error: sqlcode=3127 message=ORA-03127: no new operations allowed until the active operation ends
2496( 3240) 12/18/2007 10:39:06 RTE sqlExec error statement=SELECT NUMBERPRGN,DESCRIPTION,JUSTIFICATION FROM cm3rm1 WHERE NUMBERPRGN IN (:nameh0, :nameh1, :nameh2, :nameh3, :nameh4, :nameh5, :nameh6, :nameh7, :nameh8, :nameh9, :nameh10, :nameh11, :nameh12, :nameh13, :nameh14, :nameh15, :nameh16)
2496( 3240) 12/18/2007 10:39:06 RTE sqlExec error: sqlcode=3127 message=ORA-03127: no new operations allowed until the active operation ends

[benvargas]

This may help you...

ServiceCenter 6.1 - push to Oracle 10.2 errortext=ORA-03127
error message sqlExec error: sqlcode=3127 errortext=ORA-03127: no new operations allowed until the active operation ends

Document ID: 765826
Document Type: Issue Resolution
SCR Number:
Published Status: Published

ISSUE

When converting to Oracle 10.2 and using the following Disposition of Arrays options: Blob in Main Table, Blob as Alias Table, and Field in Main Table.

Field in Alias Table and Multi-Row Array Table do not cause error

error message

sqlExec error: sqlcode=3127 errortext=ORA-03127: no new operations allowed until the active operation ends


ENVIRONMENT
Category: ServiceCenter
Sub-Category: Applications
Version: 6.1.1.0
Build:
Database: Oracle 10.2
Platform:
Additional Information:

CAUSE

Need to set the code page to a character encoding supported by your RDBMS such as Unicode (UTF-8). To set the code page to Unicode (UTF-8) add the parameter dblanguage:utf8 to the sc.ini file.


RESOLUTION


add dblanguage:utf8 in your sc.ini

[fv2008]

yes,you are right .thank you