HP SM 9.20 migration from HP SM 7.1 - forms insert failure (1174 Views)
Reply
vps
Frequent Visitor
vps
Posts: 4
Registered: ‎06-28-2011
Message 1 of 9 (1,174 Views)

HP SM 9.20 migration from HP SM 7.1 - forms insert failure

Hi, I have forms in HP SM 7.1 with MS SQL server. Now i have installed & configured HP SM 9.20 for migration.I have imported the forms from HM SM 7.1 into HP SM 9.20 with same database in different schema. Q1. While trying to add a record in HP SM 9.20 even though provided request Id in the form, it gives me the below error in message. Please find the attachment for error message. Please help me asap(urgent need). Thanks
Honored Contributor
Jacob Heubner
Posts: 4,177
Registered: ‎07-21-2008
Message 2 of 9 (1,159 Views)

Re: HP SM 9.20 migration from HP SM 7.1 - forms insert failure

There's no attachment. post your error message.
vps
Frequent Visitor
vps
Posts: 4
Registered: ‎06-28-2011
Message 3 of 9 (1,149 Views)

Re: HP SM 9.20 migration from HP SM 7.1 - forms insert failure

Please find the error message from Form-Message after importing HP SM 7.1 forms into HM SM 9.20 The record being added contains all NULL keys (se.base.method,add.record.radd) file:(PeregrineToCEP) key:(requestId=) (se.base.method,add.record.radd) This record contains all null keys. The record being added contains all NULL keys (se.base.method,add.record.radd) file:(PeregrineToCEP) key:(requestId=) (se.base.method,add.record.radd) This record contains all null keys. D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl file loaded. 11 total records processed in 00:00:08. 0 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl updated in unload. 1 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl added to unload. 0 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl skipped in unload. 0 errors detected loading to unload from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl. 1 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl loaded to unload, 00:00:08 elapsed. Loading unload file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl 0 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl updated in formatctrl. 1 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl added to formatctrl. 0 errors detected loading to formatctrl from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl. 1 records loaded into formatctrl file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl Loading formatctrl file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl 0 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl updated in formatctrl. 1 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl added to formatctrl. 0 errors detected loading to formatctrl from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl. 1 records loaded into formatctrl file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl Loading formatctrl file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl 0 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl updated in format. 1 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl added to format. 0 errors detected loading to format from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl. 1 records loaded into format file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl Loading format file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl 0 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl updated in format. 1 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl added to format. 0 errors detected loading to format from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl. 1 records loaded into format file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl Loading format file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl 0 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl updated in extaccess. 1 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl added to extaccess. 0 errors detected loading to extaccess from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl. 1 records loaded into extaccess file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl Loading extaccess file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl 0 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl updated in extaccess. 1 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl added to extaccess. 0 errors detected loading to extaccess from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl. 1 records loaded into extaccess file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl Loading extaccess file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl 0 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl updated in dbdict. 1 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl added to dbdict. 0 errors detected loading to dbdict from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl. 1 records loaded into dbdict file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl Loading dbdict file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl 0 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl updated in dbdict. 1 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl added to dbdict. 0 errors detected loading to dbdict from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl. 1 records loaded into dbdict file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl Loading dbdict file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl 0 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl updated in datadict. 1 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl added to datadict. 0 errors detected loading to datadict from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl. 1 records loaded into datadict file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl Loading datadict file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl 0 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl updated in datadict. 1 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl added to datadict. 0 errors detected loading to datadict from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl. 1 records loaded into datadict file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl Loading datadict file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl and pasted here the sm.log file entry for the same error, 3728( 6640) 06/29/2011 05:07:18 RTE I Detected that table 'PEREGRINETOCEPM1' is case sensitive, changed flag in dbdict record for file 'PeregrineToCEP' 3728( 6640) 06/29/2011 05:07:20 RTE I Detected that table 'CEPTOPEREGRINEM1' is case sensitive, changed flag in dbdict record for file 'CEPToPeregrine' 6600( 6224) 06/29/2011 05:10:39 RTE W WARNING: lock [7]Cache manager waited on for 5000 milliseconds 3728( 6640) 06/29/2011 05:12:47 RTE E Error in fetching sequence number for file requestId 3728( 6640) 06/29/2011 05:12:47 RTE I dbInsert: The record being added contains all NULL keys 3728( 6640) 06/29/2011 05:12:47 RTE I dbInsert: file:(PeregrineToCEP) key:(requestId=) 3728( 6640) 06/29/2011 05:17:13 RTE E Error in fetching sequence number for file requestId 3728( 6640) 06/29/2011 05:17:13 RTE I dbInsert: The record being added contains all NULL keys 3728( 6640) 06/29/2011 05:17:13 RTE I dbInsert: file:(PeregrineToCEP) key:(requestId=) Please help me out from this issue. Thanks Saravanan P
vps
Frequent Visitor
vps
Posts: 4
Registered: ‎06-28-2011
Message 4 of 9 (1,140 Views)

Re: HP SM 9.20 migration from HP SM 7.1 - forms insert failure

Please find the error message from Form-Message after importing HP SM 7.1 forms into HM SM 9.20 The record being added contains all NULL keys (se.base.method,add.record.radd) file:(PeregrineToCEP) key:(requestId=) (se.base.method,add.record.radd) This record contains all null keys. The record being added contains all NULL keys (se.base.method,add.record.radd) file:(PeregrineToCEP) key:(requestId=) (se.base.method,add.record.radd) This record contains all null keys. D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl file loaded. 11 total records processed in 00:00:08. 0 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl updated in unload. 1 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl added to unload. 0 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl skipped in unload. 0 errors detected loading to unload from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl. 1 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl loaded to unload, 00:00:08 elapsed. Loading unload file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl 0 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl updated in formatctrl. 1 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl added to formatctrl. 0 errors detected loading to formatctrl from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl. 1 records loaded into formatctrl file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl Loading formatctrl file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl 0 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl updated in formatctrl. 1 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl added to formatctrl. 0 errors detected loading to formatctrl from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl. 1 records loaded into formatctrl file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl Loading formatctrl file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl 0 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl updated in format. 1 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl added to format. 0 errors detected loading to format from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl. 1 records loaded into format file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl Loading format file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl 0 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl updated in format. 1 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl added to format. 0 errors detected loading to format from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl. 1 records loaded into format file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl Loading format file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl 0 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl updated in extaccess. 1 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl added to extaccess. 0 errors detected loading to extaccess from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl. 1 records loaded into extaccess file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl Loading extaccess file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl 0 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl updated in extaccess. 1 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl added to extaccess. 0 errors detected loading to extaccess from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl. 1 records loaded into extaccess file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl Loading extaccess file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl 0 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl updated in dbdict. 1 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl added to dbdict. 0 errors detected loading to dbdict from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl. 1 records loaded into dbdict file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl Loading dbdict file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl 0 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl updated in dbdict. 1 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl added to dbdict. 0 errors detected loading to dbdict from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl. 1 records loaded into dbdict file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl Loading dbdict file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl 0 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl updated in datadict. 1 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl added to datadict. 0 errors detected loading to datadict from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl. 1 records loaded into datadict file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl Loading datadict file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl 0 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl updated in datadict. 1 records from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl added to datadict. 0 errors detected loading to datadict from D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl. 1 records loaded into datadict file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl Loading datadict file from external file: D:\Users\pps\Peregrine\SM71PDC28\SMCEP71.unl sm.log error message 3728( 6640) 06/29/2011 05:07:18 RTE I Detected that table 'PEREGRINETOCEPM1' is case sensitive, changed flag in dbdict record for file 'PeregrineToCEP' 3728( 6640) 06/29/2011 05:07:20 RTE I Detected that table 'CEPTOPEREGRINEM1' is case sensitive, changed flag in dbdict record for file 'CEPToPeregrine' 6600( 6224) 06/29/2011 05:10:39 RTE W WARNING: lock [7]Cache manager waited on for 5000 milliseconds 3728( 6640) 06/29/2011 05:12:47 RTE E Error in fetching sequence number for file requestId 3728( 6640) 06/29/2011 05:12:47 RTE I dbInsert: The record being added contains all NULL keys 3728( 6640) 06/29/2011 05:12:47 RTE I dbInsert: file:(PeregrineToCEP) key:(requestId=) 3728( 6640) 06/29/2011 05:17:13 RTE E Error in fetching sequence number for file requestId 3728( 6640) 06/29/2011 05:17:13 RTE I dbInsert: The record being added contains all NULL keys 3728( 6640) 06/29/2011 05:17:13 RTE I dbInsert: file:(PeregrineToCEP) key:(requestId=) Please help me out. Thanks in Advance, P.Saravanan
Honored Contributor
Vadim Gorda
Posts: 5,822
Registered: ‎11-10-2008
Message 5 of 9 (1,132 Views)

Re: HP SM 9.20 migration from HP SM 7.1 - forms insert failure

Not sure in what is the problem but screenshot and not copy past of text will be really helpful for others.

Frequent Advisor
MIGUEL G_1
Posts: 35
Registered: ‎05-08-2011
Message 6 of 9 (1,130 Views)

Re: HP SM 9.20 migration from HP SM 7.1 - forms insert failure

Hello.

 

 Im migrated 7.11 to 9.20. first i review that dbdict 920 and 7.11, probsummary, incident, screlation, ocmq, ocml, Approval, ApprovalLog it have the same fields.

 

After i deleted all record in 9.20 of probsummary, incident, screlation, ocmq, ocml, sla, slo, Approval, ApprovalLog

 

The migration i maked by SQL Server, i go to 7.11 database and export table by table to sql databe 9.20

never select more than one table, always export one to one.

 

When you finish exportation then do you log in SM 9.20 and go to counter and number table, search

refence of your tables probsummary, incident, Approval, screlation etc.. where appear reference of you tables

Then put the same value counter and number from 7.11 with this you continue the last number tickets.

 

To finish, dont migrato table format because there are different that 7.11 or down,  if you have contigurated any FC or LINK to format i recommend copy and paste the code from 7.11 to 9.20

 

I hope help you.

 

bye.

Miguel Guerrero.

 

 

 

 

 

 

Honored Contributor
-m-
Posts: 989
Registered: ‎02-22-2011
Message 7 of 9 (1,123 Views)

Re: HP SM 9.20 migration from HP SM 7.1 - forms insert failure

HP provides an Application Upgrade utility which should be used to upgrade from 7.11 to 9.20. While it is possible to migrate by importing/loading data, this process can lead to different problems (some obvious, some not). Additionally, there may be supportability issues since the HP utility was bypassed in favor of an alternative method.

 

The error means that the required fields are not populated in the PeregrineToCEP file. Does your company keep work-logs or statements of work which might document how this custom file was implemented? As Miguel stated, the two most common areas for generating a unique identifier are the number and counter files. Counters work by simply creating the record, but number records require an actual call by a RAD Application or RAD function (from Format Control Subroutines, Process records, etc).

Valued Contributor
Dominic McConnell
Posts: 200
Registered: ‎10-14-2009
Message 8 of 9 (1,086 Views)

Re: HP SM 9.20 migration from HP SM 7.1 - forms insert failure

With the Application Upgrade utility do you still need to manually recreate forms that you tailored in 7.x when you upgrade to 9.20?

vps
Frequent Visitor
vps
Posts: 4
Registered: ‎06-28-2011
Message 9 of 9 (1,068 Views)

Re: HP SM 9.20 migration from HP SM 7.1 - forms insert failure

Hi, Actually i suppose to unload the forms HP SM 7.1 and import it in HP SM 9.20. Should work in HP SM 9.20. It will use same database(MS SQL Server) with different schema. I unloaded the HP SM 7.1 and imported in HP SM 9.20. After i imported, while trying to add data in form, its gives NULL constraints error message. I have attached unload files snapshot and error message.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.