[Info-ingres] Occasional SELECT statement error.

[Darren Harvey]

Hi All

We are getting the following popup message occasionally at customers sites.  The process that calls the procedure that contains the SELECT statement (screenshot below) is an end of week process, and we have customers who run the process without the error for lots of weeks, and then one week they get the error message, and then the next time they run the process there is no popup error message.

Does anyone have any suggestions/thoughts as to why this problem doesn’t occur every time the process is run, but is just an occasional problem?

Thanks

Darren


Error Message

[cid:image002.jpg at 01D61E2C.35C203B0]



SELECT statement in procedure that is getting error.


[cid:image004.jpg at 01D61E2C.35C203B0]


The ACTIAN Generic Error Code for -3200 is described as follows:
[cid:image012.jpg at 01D61E2C.35C203B0]

Darren Harvey
Senior Developer
M +61 400 398 188
P +61 3 9922 5519
Teams or Skype for Business ID darren.harvey at fusion5.com.au
www.fusion5.com.au<https://www.fusion5.com.au?utm_source=F5-Int.Sig&utm_medium=email&utm_campaign=AskUs2020/> [cid:image005.png at 01D61E25.7D75BE60] <https://www.linkedin.com/company/fusion5> [cid:image006.png at 01D61E25.7D75BE60] <https://www.instagram.com/jemini_hrpayroll_software/>
[cid:image007.jpg at 01D61E25.7D75BE60]<http://business.fusion5.com.au/HCM2020?utm_source=F5-Int.Sig&utm_medium=email&utm_campaign=HCM2020Conf>
Fusion5 | Level 27, 570 Bourke Street, Melbourne, 3000, Australia
This email and any attachments are confidential and intended exclusively for the person to whom the email is addressed. Please see our Privacy Policy<https://www.fusion5.com.au/privacy-policy/>
Are you interested in Fusion5’s COVID-19 business update?　
Please visit https://www.fusion5.com.au/covid-19-update/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20200429/571d57a6/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.png
Type: image/png
Size: 974 bytes
Desc: image005.png
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20200429/571d57a6/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image006.png
Type: image/png
Size: 3560 bytes
Desc: image006.png
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20200429/571d57a6/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image007.jpg
Type: image/jpeg
Size: 43812 bytes
Desc: image007.jpg
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20200429/571d57a6/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 16530 bytes
Desc: image002.jpg
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20200429/571d57a6/attachment-0001.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.jpg
Type: image/jpeg
Size: 38721 bytes
Desc: image004.jpg
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20200429/571d57a6/attachment-0002.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image012.jpg
Type: image/jpeg
Size: 17037 bytes
Desc: image012.jpg
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20200429/571d57a6/attachment-0003.jpg>