topic Re: Error generated when the _PRODSAVAIL dataset is created when running with parallel execution in SAS Programming

topic Re: Error generated when the _PRODSAVAIL dataset is created when running with parallel execution in SAS Programming https://communities.sas.com/t5/SAS-Programming/Error-generated-when-the-PRODSAVAIL-dataset-is-created-when/m-p/755241#M238315 <P>Thanks for your suggestion - my user tried and this helped.  </P><P> </P><P>In the meantime I also raised the issue with SAS Technical Support and they came back with this response - looks like the problem will be fixed when we finish migrating everyone to EGuide 8.3.</P><P> </P><P class="cs2654ae3a"><SPAN class="cs1e88c66e1"><SPAN style="font-size: 10.0pt;">Hi Valerie,</SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="cs1e88c66e1"><SPAN style="font-size: 10.0pt;"> </SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="cs1e88c66e1"><SPAN style="font-size: 10.0pt;">Thank you for your email regarding the error you are seeing with SAS EG :</SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="csedbfcf261"><SPAN style="font-size: 8.0pt;"> </SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="csedbfcf261"><SPAN style="font-size: 8.0pt;">504        data _prodsavail;</SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="csedbfcf261"><SPAN style="font-size: 8.0pt;">                ___________</SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="csedbfcf261"><SPAN style="font-size: 8.0pt;">                180</SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="csedbfcf261"><SPAN style="font-size: 8.0pt;"> </SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="csedbfcf261"><SPAN style="font-size: 8.0pt;">ERROR 180-322: Statement is not valid or it is used out of proper order</SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="cs1e88c66e1"><SPAN style="font-size: 10.0pt;"> </SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="cs1e88c66e1"><SPAN style="font-size: 10.0pt;">I've done some checking into this error and it seems that there is no way to prevent this code from running when EG starts up, but on the plus side you can just ignore the error message.</SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="cs1e88c66e1"><SPAN style="font-size: 10.0pt;"> </SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="cs1e88c66e1"><SPAN style="font-size: 10.0pt;">The problem is occurring because there is an issue with the way that the SAS EG parallel sessions disconnect from the server when run as a Parallel execution.   </SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="cs1e88c66e1"><SPAN style="font-size: 10.0pt;"> </SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="cs1e88c66e1"><SPAN style="font-size: 10.0pt;">An official Defect is in place for this issue and it has been fixed in SAS EG 8.x1 onwards, but unfortunately there are no plans to fix this in SAS EG 7.x versions.</SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="cs1e88c66e1"><SPAN style="font-size: 10.0pt;"> </SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="cs1e88c66e1"><SPAN style="font-size: 10.0pt;">There is a suggested Work around that you may find helpful . In SAS EG -> Project -> Properties -> Code Submission '</SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="cs1e88c66e1"><SPAN style="font-size: 10.0pt;"> </SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="cs1e88c66e1"><SPAN style="font-size: 10.0pt;">Ensure that "Allow parallel execution on same server " is deselected.</SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="cs1e88c66e1"><SPAN style="font-size: 10.0pt;"> </SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="cs1e88c66e1"><SPAN style="font-size: 10.0pt;">This should minimise the potential for the error to appear.</SPAN></SPAN></P> Tue, 20 Jul 2021 06:53:57 GMT ValStrassburg 2021-07-20T06:53:57Z Error generated when the _PRODSAVAIL dataset is created when running with parallel execution https://communities.sas.com/t5/SAS-Programming/Error-generated-when-the-PRODSAVAIL-dataset-is-created-when/m-p/752087#M236854 <P>We have a team who are running their code with parallel execution in EGuide 7.15.  9 times out of 10 their code works perfectly.  The other time they are getting an error when the background SAS wrapper code, which executes before their own code, tries to create the temporary _PRODSAVAIL data. They are getting a 'statement is not valid or it is used out of context' error which usually means there is some sort of syntax error.  </P><P> </P><P>It doesn't seem to affect the results of their own code.</P><P> </P><P>Does anyone know of a way to prevent this error appearing or to stop the background wrapper code being run?</P><P> </P><P>Excerpt from the SAS log.  The user's own code starts after this and runs ok.</P><P> </P><P>504        data _prodsavail;</P><P>ERROR 180-322: Statement is not valid or it is used out of proper order.</P><P>505            length name $ 8 fullname $ 30 prodcode $ 10 prodmod $ 10 installed $ 12;</P><P>ERROR 180-322: Statement is not valid or it is used out of proper order.</P><P>506            input fullname 1-30 name 32-39 prodcode prodmod;</P><P>ERROR 180-322: Statement is not valid or it is used out of proper order.</P><P>507            licensed=sysprod(prodcode);</P><P>ERROR 180-322: Statement is not valid or it is used out of proper order.</P><P>508            installed = tslvl(prodmod%GetTslvlParam2);</P><P>ERROR 180-322: Statement is not valid or it is used out of proper order.</P><P>509        cards;</P><P>ERROR 180-322: Statement is not valid or it is used out of proper order.</P><P>510        Base                           BASE    prodnum0    sasmeans</P><P>ERROR 180-322: Statement is not valid or it is used out of proper order.</P><P>511        SAS/STAT                       STAT    stat        sasglm</P><P>512        SAS/GRAPH                      GRAPH   graph       sasgchar</P><P>513        SAS/GIS                        GIS     prodnum28   sasgis</P><P>514        SAS/ETS                        ETS     ets         sasarima</P><P>515        SAS/QC                         QC      qc          sascapab</P><P>516        SAS/CONNECT                    CONNECT prodnum15   saszrlnk</P><P>517        SAS/ACCESS PC Files            ACCPC   prodnum208  sasdbf</P><P>518        ;</P> Mon, 05 Jul 2021 13:26:51 GMT https://communities.sas.com/t5/SAS-Programming/Error-generated-when-the-PRODSAVAIL-dataset-is-created-when/m-p/752087#M236854 ValStrassburg 2021-07-05T13:26:51Z Re: Error generated when the _PRODSAVAIL dataset is created when running with parallel execution https://communities.sas.com/t5/SAS-Programming/Error-generated-when-the-PRODSAVAIL-dataset-is-created-when/m-p/752106#M236861 <P>To prevent the background wrapper code from appearing in the log you can go to top menu</P> <P>Tools - Options - Results - General - uncheck "Show generated wrapper code in log".  This will not correct the error, but will only prevent Enterprise Guide wrapper code from appearing in the log.</P> Mon, 05 Jul 2021 15:39:26 GMT https://communities.sas.com/t5/SAS-Programming/Error-generated-when-the-PRODSAVAIL-dataset-is-created-when/m-p/752106#M236861 JOL 2021-07-05T15:39:26Z Re: Error generated when the _PRODSAVAIL dataset is created when running with parallel execution https://communities.sas.com/t5/SAS-Programming/Error-generated-when-the-PRODSAVAIL-dataset-is-created-when/m-p/755241#M238315 <P>Thanks for your suggestion - my user tried and this helped.  </P><P> </P><P>In the meantime I also raised the issue with SAS Technical Support and they came back with this response - looks like the problem will be fixed when we finish migrating everyone to EGuide 8.3.</P><P> </P><P class="cs2654ae3a"><SPAN class="cs1e88c66e1"><SPAN style="font-size: 10.0pt;">Hi Valerie,</SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="cs1e88c66e1"><SPAN style="font-size: 10.0pt;"> </SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="cs1e88c66e1"><SPAN style="font-size: 10.0pt;">Thank you for your email regarding the error you are seeing with SAS EG :</SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="csedbfcf261"><SPAN style="font-size: 8.0pt;"> </SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="csedbfcf261"><SPAN style="font-size: 8.0pt;">504        data _prodsavail;</SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="csedbfcf261"><SPAN style="font-size: 8.0pt;">                ___________</SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="csedbfcf261"><SPAN style="font-size: 8.0pt;">                180</SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="csedbfcf261"><SPAN style="font-size: 8.0pt;"> </SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="csedbfcf261"><SPAN style="font-size: 8.0pt;">ERROR 180-322: Statement is not valid or it is used out of proper order</SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="cs1e88c66e1"><SPAN style="font-size: 10.0pt;"> </SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="cs1e88c66e1"><SPAN style="font-size: 10.0pt;">I've done some checking into this error and it seems that there is no way to prevent this code from running when EG starts up, but on the plus side you can just ignore the error message.</SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="cs1e88c66e1"><SPAN style="font-size: 10.0pt;"> </SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="cs1e88c66e1"><SPAN style="font-size: 10.0pt;">The problem is occurring because there is an issue with the way that the SAS EG parallel sessions disconnect from the server when run as a Parallel execution.   </SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="cs1e88c66e1"><SPAN style="font-size: 10.0pt;"> </SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="cs1e88c66e1"><SPAN style="font-size: 10.0pt;">An official Defect is in place for this issue and it has been fixed in SAS EG 8.x1 onwards, but unfortunately there are no plans to fix this in SAS EG 7.x versions.</SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="cs1e88c66e1"><SPAN style="font-size: 10.0pt;"> </SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="cs1e88c66e1"><SPAN style="font-size: 10.0pt;">There is a suggested Work around that you may find helpful . In SAS EG -> Project -> Properties -> Code Submission '</SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="cs1e88c66e1"><SPAN style="font-size: 10.0pt;"> </SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="cs1e88c66e1"><SPAN style="font-size: 10.0pt;">Ensure that "Allow parallel execution on same server " is deselected.</SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="cs1e88c66e1"><SPAN style="font-size: 10.0pt;"> </SPAN></SPAN></P><P class="cs2654ae3a"><SPAN class="cs1e88c66e1"><SPAN style="font-size: 10.0pt;">This should minimise the potential for the error to appear.</SPAN></SPAN></P> Tue, 20 Jul 2021 06:53:57 GMT https://communities.sas.com/t5/SAS-Programming/Error-generated-when-the-PRODSAVAIL-dataset-is-created-when/m-p/755241#M238315 ValStrassburg 2021-07-20T06:53:57Z