Blocksize error when adding model to database of new SSM 7.5 unix system

[Former Member]

Hi,

I have installed a new SSM 7.5 system on AIX.

I copied a model from a Windows 2003 64bit based SSM 7.5 system and tried adding it to the database of the new AIX based system.

Getting the following error:

LSS> SUPERVISOR ADD DATABASE ZMODEL

DB-017:

Invalid Database Blocksize Specified on Database ZMODEL

Any advise on how to get around this?

Thanks

[Bob_McGlynn · Accepted solution]

Adriaan,

Pedro is correct, you cannot merely copy a model into PAS, you have to create a new model shell and load the copied model into that.

First in your other system you display the parameters of the ZMODEL database so you can replicate the model structure.

SUP SHO DAT ZMODEL

Make note of the Blocksize, Blocks, Members, Observations, etc.

In that system you dump the model

USE ZMODEL

DUMP (name to use to transport)

That will create a file in the HOME directory that you copy and add to the HOME directory of the new system.

In your new system you add the copy of the dump to the HOME directory.

Create a new model shell in PAS

SUP CRE DAT (new model name) BLO XXX BLK XK MEM XXXXX OBS XXXXXX (where all the names and X's are the name and numbers you noted)

New database will be created, then

USE (new model name)

LOAD (name of model used to transport)

You should now have your moved your model.

Regards,

Bob

[Former Member · Accepted solution]

Hi Bob and Pedro,

Thanks for help so far.

I am trying to import the dump of the model but it does not get very far before failing with the messages below

Any ideas?

Remove Procedure EXCEL UPLOAD

^

Expected end of line

Thanks

[Bob_McGlynn · Accepted solution]

Adriaan,

The issue is the name of the procedure, the space in the procedure name is throwing the error. The procedure would have to be named either EXCEL_UPLOAD or 'EXCEL UPLOAD' .

Regards,

Bob

[Former Member · Accepted solution]

Thanks Bob.

I changed it to 'EXCEL UPLOAD' and it worked.

Now wondering why the DUMP of the model created that command incorrectly in the dump file.

Edited by: Adriaan Van der Bank on Jun 8, 2011 3:37 PM

[Former Member]

Adriaan,

you must dump the model, a simple copy of the database file will not work because the server's use different OS.

Regards

Pedro