OSI Print Spec Recovery

OSI Print Spec Recovery

 

To recover the print specs, they need a recently updated database, to copy data from.  You need to do the following to move the data:

 

In prod, verify the following tables are empty:

Prtspec

Ntwknodeprtspec

Orgprtspec

 

If they are empty, check the recent copy of the database.  If the same tables are not empty, copy them to the prod environment (we used SQL Develper, and use the “Export” of the table in the Insert format (a .sql file is created, with an insert statement for every row)).  Don’t forget to commit.

 

In the Appl tabl, all the prtspec records would have been changed out.  Run the following query in the recent copy to generate an update script for production:

 

select 'update appl set prtspeccd = '’‘ || prtspeccd || '’‘ where prtspec is null and applnbr = ' || applnbr || ';' from appl where prtspeccd is not null;

 

run the update statements generated in production, commit, and refresh cache. 

 

Have users test.

 

 

Thank you,

Carley Parker