Reset SPC on Deployment Server

[Maestro19]

Goal: Repair SPECS in <PLANNER> and Reset SPC Codes on Deployment Server in the JDEPLAN Environment. Problem: While accessing the Server Security setup on Application P98SRV, I receive the following attached message “DeplSvrSPCerror.log”. It has been suggested to regenerate the global tables. The R92TAM & R98CRTGL were used for regeneration. This proved to be unsuccessful. Secondly, it was suggested to rebuild the Planner Environment on another server/sandbox and replicate the <PLANNER> directory back over to the deployment server. This is currently a work in progress. Are there any other suggestions to resolving this issue? Thanks!

 

[got_to_love_jde]

Maestro,
I assume you have tested your ODBC connections ?
Good Luck,
Dave

 

[Maestro19]

Hi Dave,

The ODBC's were already tested successfully. Any other suggestions? Thanks!

Mervin W. January
Sr. Application Systems Administrator
OneNeck IT Outsourcing Solutions
Office: (480)315-3079 Mobile: (602)317-2701
Email: [email protected]





OneWorld Xe, SP 18, Update 4
NT 2000, SQL 2000

 

[AntonUsanov]

Hello.
You can reset SPC from any environment on any workstation.
You need check B7333 shared folder and permissions for Client directory (and its files).

 

[vikingsteve]

Maybe you can get the PLANNER directory by installed the latest planner esu JD17626.?

 

[Maestro19]

Thanks for you help Steve. Here are the completed steps with additional
details.

The SPC code on the Deployment Server has been installed successfully.=20

The resolution for this issue were the following steps:=09

Step 1: Recreate Planner Environment on Sandbox
Step 2: Backup and delete Planner Environment from Deployment =
Server(HRSVDS)
Step 3: Migrate new Planner Environment from Sandbox to Deployment
Server(HRSVDS)
Step 4: Restore the Planner database (jdeplan.mdb) from backup in step =
#2
Step 5: Re-Extract ESU's to Planner Environment (JD17626 & JD12367)
Step 6: Log-in to Planner Environment and validate new SPC code
Step 7: Validate new code on client machines

Mervin W. January
Sr. Application Systems Administrator
OneNeck IT Outsourcing Solutions
Office: (480)315-3079 Mobile: (602)317-2701
Email: [email protected]





OneWorld Xe, SP 18, Update 4
NT 2000, SQL 2000