Sequencer is getting aborted continuously

[pras]

Hi all

My sequencer is getting aborted continiously
the error is

TgtFinDeferRevenueStage..Tr_ContractAmount: |DSU.ExecSH is not cataloged|

please explain about this,and what should i do to overcome this

thanks
pras....

[ArndW]

That error message points to a corrupt project, as that routine is read-only and should always be present.

Is this a new project, or has something catastrophic happened to it recently?

Look in your Manager -> Routines -> Built-in -> Before/After. Is there a "ExecSH" located there? If you go to TCL or the Administrator you can execute a "LIST VOC DSU.ExecSH" it should have 1 entry.

[chulett]

Actually, aren't they all cataloged in upper case? DSU.EXECSH And I thought that prefix was reserved for User written routines.

[ray.wurlod]

You are trying to invoke ExecSH from one of your own Routines.

ExecSH is a subroutine. Both DSU.ExecSH and DSX.EXECSH should be cataloged; execute the following command to determine that they are:

Code: Select all

SELECT @ID FMT '40L' FROM VOC WHERE EVAL 'UPCASE(@ID)' LIKE '%EXECSH%';

If you do not get four rows in the report, please post back, and we will guide you through recovering the project.

Otherwise, note that you need the prefix in the CALL statement in your routine. The ExecSH subroutine can not be invoked as a function.

Code: Select all

CALL DSU.ExecSH(InputValue, ErrorFlag)

A better solution would be to replace ExecSH with a call to DSExecute().

[pras]

That error message points to a corrupt project, as that routine is read-only and should always be present.

Is this a new project, or has something catastrophic happened to it recently?

Look in your Manager -> Routines -> Built-in -> Before/After. Is there a "ExecSH" located there? If you go to TCL or the Administrator you can execute a "LIST VOC DSU.ExecSH" it should have 1 entry.

hi arn

ExecSH is located there in the Manager,
i tried executing LIST VOC DSU.ExecSH, it is returning 0 Records

can u tell me how i can resolve or what i should do

thanks
Pras....

[balajisr]

Did you try executing

Code: Select all

LIST VOC DSX.ExecSH

If so what is the result?

[ray.wurlod]

It appears that the installation of the project has not been completely successful, or that someone has removed some catalog entries. Can you please count all records from the VOC whose names begin with DS, by type?

Code: Select all

SELECT "TYPE", COUNT(*) FROM VOC WHERE @ID LIKE 'DS%' GROUP BY "TYPE";

This will give some idea of how incomplete the installation is. If only a few items are missing you may be able to copy them from another project. If many are missing, then reinstalling the server (which updates all projects) may be a quicker solution.
Expected results (from version 7.5x2):

Code: Select all

>SELECT "TYPE", COUNT(*) FROM VOC WHERE @ID LIKE 'DS%' GROUP BY "TYPE";
TYPE    COUNT ( * )

                  2
D                 1
F                35
M                 3
PA                2
Q                 1
V               334
X                 1

8 records listed.

[sb_akarmarkar]

Please try following...

SELECT * FROM VOC WHERE NAME LIKE 'DSX.EXECSH'

in TCL

Thanks,
Anupam

[pras]

Did you try executing

Code: Select all

LIST VOC DSX.ExecSH

If so what is the result?

i tried this one too..

the result is the same "0 records"

[pras]

Please try following...

SELECT * FROM VOC WHERE NAME LIKE 'DSX.EXECSH'

in TCL

Thanks,
Anupam

Hi Anupam

when i executed that i got one record listed as
NAME TYPE DESC
dsc.execsh v v

i couldn't figure out , can u explain

thanks
Pras....

[sb_akarmarkar]

Try this also....

SELECT * FROM VOC WHERE NAME LIKE 'DSU.ExecSH'

any records?

if not copy the code of ExecSH from manager and create new routine and compile....

and execute the above query with new routine name start with DSU....


I hope this will help to catalog routine....


Thanks,
Anupam

[ArndW]

It isn't worth fixing the DSU.ExecSH until you know if this is the only problem, please do what Ray suggested to see how much might be missing.