ERROR: Libref DIMON is not assigned.

[srivalliavadhanula]

I have tried to access the link(http://a3-monitoring.example.com:7980/eom/dimon) with user sasdemo for the first time and I have got Stored Process Error. I have created a ODBC Library with libref dimon to access the tables from Postgres and I am able to assign the library from EG with sasdemo user. Can you please help me with this error? I have attached the log.

eom_log.txt eom_log.txt

[bheinsius]

It seems that you have used a different name for the library than the default DIMON. In that case you shoud update the dimon_usermods.sas file to reflect that:

/ If you use a library other than the default DIMON, allocate it here / / %libname dimon (dimonpos); /

[bheinsius]

If you did use the name DIMON then your DIMON library is maybe not set as pre-assigned in metadata? Please set it to pre-assigned since the dimon code does expects it to be assigned.

[srivalliavadhanula]

I have set the library as pre-assigned. Even I have used the libref as dimon.

[bheinsius]

the error is:

ERROR: Libref DIMON is not assigned.

so DIMON is somehow not assigned in your stored process server session. From this distance I cannot see why. Your could maybe ssh into your server with your sassrv account, navigate to

<sasconfig>/Lev1/SASApp/StoredProcessServer/

and execute

./StoredProcessServer.sh -nodms

to find the reason.

[srivalliavadhanula]

I have tried to execute ./StoredProcessServer.sh -nodms with sassrv account and the libref was assigned in that session. Please find below log.

NOTE: SAS initialization used: real time 0.02 seconds cpu time 0.02 seconds

NOTE: Libref SASDATA successfully assigned from logical server. NOTE: Libref VALIB successfully assigned from logical server. NOTE: Libref STPSAMP successfully assigned from logical server. NOTE: Libref DIMON successfully assigned from logical server.

NOTE: AUTOEXEC processing beginning; file is /sas/config/Lev1/SASApp/StoredProcessServer/autoexec.sas.

NOTE: Libref DIMON was successfully assigned as follows: Engine: ODBC Physical Name: test

NOTE: AUTOEXEC processing completed.

1? endsas;

1 endsas;

NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 59.65 seconds cpu time 0.07 seconds

[sassrv@a3-monitoring StoredProcessServer]$

[srivalliavadhanula]

Thanks for your help! Now I am not getting the above error. :)

[bheinsius]

what was the issue?

[srivalliavadhanula]

I have added the libname statement in autoexec_usermods.sas and restarted the mid services.

Now I am able to see my scheduled flow in the URL but it is not showing the END Time of the flow and when I open the dimon.DIMON_RUN_STATS table, I find that there are 0 observations in the table.

All the other tables, there are observations related to flow.

[bheinsius]

Did the scheduled flow run? It is difficult to debug this remotely. if you need help a teamviewer or webex sessions may be better.

[srivalliavadhanula]

Can we schedule a webex at 11 AM EST today. If you are available, can you send me your personal id, I will send you the webex link.

[bheinsius]

please email me your contact details (see my website, info works)

[srivalliavadhanula]

I have mailed you my contact details to this mail info@eom.nl . Please let me know your available time.