web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

unhandled script exception: SCRIPTS - data area EXCEPTION CLASS SCRIPT OUT_OF_RANGE SCRIPT "CMD INDEX"

(0) ShareShare
ReportReport
Posted on by 60

We are getting the following error when doing a Journal Entry Inquiry and trying to view the Source Document for PMTRX transactions

handled script exception: SCRIPTS - data area EXCEPTION CLASS SCRIPT OUT_OF_RANGE SCRIPT "CMD INDEX"

We have to click the exception box multiple times until it finally clears and loads the Purchasing Zoom window. I have tried running check links and that has not cleared the issue, how can I get this error to clear? We are on Dynamics GP 2018 R2

Categories:
I have the same question (0)
  • Suggested answer
    Derek Albaugh Profile Picture
    on at

    This type of error, we actually see for several different issues, so it's more generic than anything specific.

    For starters, we'd need to verify things like:

    --If the issue is when attempting to view source document for PMTRX transactions, are there any modified windows or reports in play?

    --If Dynamics GP is installed on multiple machines, do we see this same type of issue on all GP instances?

    --Can this issue be re-created at will? If so, does it occur for all users in the company database(s)?

    Another thing I'd usually recommend is, on one of the machines that has Dynamics GP installed, have all users log out, then rename the GP directory itself, then run a Repair against that instance of Dynamics GP, which will re-create the entire GP directory, including folders and files, under the original GP directory name.  Launch Dynamics GP from this 'new' directory, and see if this error message still occurs?

     --if it does not, then we would add back any third party products or customizations, one-by-one, testing after each one, to see if the issue returns or not.

    You also can try capturing a dexsql.log of this error, to see what that shows us. As soon as the error shows, don't click anything further in Dynamics GP, but grab a copy of the dexsql.log at that point, to see what the last scripts in the log are..........which should be what is causing the error to show.

    I'd start with the above and see what that shows you.....

    Thanks

  • aliciaw Profile Picture
    60 on at

    We are trying to view the PMTRX source documents, there are no modified windows or reports that I am aware of; this is a RDP instance and I can duplicate it on the server; I can recreate it at will, it only happens so far in the one company, and multiple users can recreate it. I am not comfortable doing the directory option since I am so new, however I did run a log but it doesn't have much in it. The log is pasted below as I dont seem to be able to do an attachment.

    /*  Date: 10/21/2020  Time: 13:04:01

    stmt(132476128):*/

    {CALL DYNAMICS.dbo.zDP_SY30000F_1('aliciawhite',0,-2147483648,'aliciawhite',0,2147483647)}

    /*  Date: 10/21/2020  Time: 13:04:01

    stmt(132476128):*/

    {CALL DYNAMICS.dbo.zDP_SY30000F_1('aliciawhite',1,-2147483648,'aliciawhite',1,2147483647)}

    /*  Date: 10/21/2020  Time: 13:04:01

    stmt(132511624):*/

    { CALL DYNAMICS.dbo.zDP_SY01402SS_1 ( 'GLOBALUSER', 66 ) }

    /*  Date: 10/21/2020  Time: 13:04:02

    stmt(132468896):*/

    {CALL GPPM.dbo.zDP_PP000001F_1(NULL,NULL)}

    /*  Date: 10/21/2020  Time: 13:04:02

    stmt(132499872):*/

    {CALL GPPM.dbo.zDP_GL20000UN_4(1,316520,0,0,NULL,NULL,NULL,NULL,NULL,NULL)}

    /*  Date: 10/21/2020  Time: 13:04:02

    stmt(132498064):*/

    { CALL GPPM.dbo.zDP_SY40101SS_1 ( 2020 ) }

    /*  Date: 10/21/2020  Time: 13:04:02

    stmt(132499872):*/

    {CALL GPPM.dbo.zDP_GL20000UN_10(1,316520,2020,'1900.01.01',0.00000,316520,2020,'2020.08.05',0.00000,316520,2020,'2020.08.05',0.00000)}

    /*  Date: 10/21/2020  Time: 13:04:02

    stmt(132469800):*/

    { CALL DYNAMICS.dbo.zDP_ACTIVITYSS_1 ( 'Papa Murphys', 'aliciawhite', 0 ) }

    /*  Date: 10/21/2020  Time: 13:04:02

    stmt(132469800):*/

    { CALL DYNAMICS.dbo.zDP_SY10000SS_1 ( 'aliciawhite', 1, 0, 269, 2 ) }

    /*  Date: 10/21/2020  Time: 13:04:02

    stmt(132470704):*/

    { CALL DYNAMICS.dbo.zDP_SY05100SS_1 ( 269 ) }

    /*  Date: 10/21/2020  Time: 13:04:02

    stmt(132471608):*/

    { CALL DYNAMICS.dbo.zDP_SY10550SS_1 ( 'aliciawhite', 1 ) }

    /*  Date: 10/21/2020  Time: 13:04:02

    stmt(132472512):*/

    { CALL DYNAMICS.dbo.zDP_SY10800SS_1 ( 'DEFAULTUSER', 3830, 22054, 2 ) }

    /*  Date: 10/21/2020  Time: 13:04:02

    stmt(132469800):*/

    {CALL DYNAMICS.dbo.zDP_DDB10400F_3(0,'PM_Zoom','',0,'PM_Zoom','ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ')}

    /*  Date: 10/21/2020  Time: 13:04:02

    stmt(132469800):*/

    SELECT TOP 25 UNIQKEY,ADUPINNM,OVVCHNUM,TRKDISAV,PRTHATRB,AGEBY,APPLYBY,RMVNDHPW,RMVTRHPW,XCDMINPW,WROFPSWD,NTVCHNUM,PMNPYNBR,NXTVNDID,USRDFPR1,USRDRPR2,PMTRXDSC_1,PMTRXDSC_2,PMTRXDSC_3,PMTRXDSC_4,PMTRXDSC_5,PMTRXDSC_6,PMTRXDSC_7,PMTRXDSC_8,PMTRXABR_1,PMTRXABR_2,PMTRXABR_3,PMTRXABR_4,PMTRXABR_5,PMTRXABR_6,PMTRXABR_7,PMTRXABR_8,CHEKBKID,PCHSCHID,FRTSCHID,MSCSCHID,LSTYECAL,LSTYEFSC,Check_Format_Default,Check_Stub_Default,PRNTPRVSLYAPPLDDCS,DelUPDoc,PrntTaxDetDoc,DateSensitivitySumView,PRNTDCUR,AGEUNAPPLDCR,PMNXTSCHDNBR,ExcludeExprdDiscntsPymnt,PMDefaultCheckSort,WarnIfVenHasExistingPO,DEX_ROW_ID FROM GPPM.dbo.PM40100 WITH ( NOLOCK) ORDER BY UNIQKEY ASC

    /*  Date: 10/21/2020  Time: 13:04:02

    stmt(132505296):*/

    { CALL GPPM.dbo.zDP_SY00700SS_1 ( 'Payables Zoom' ) }

    /*  Date: 10/21/2020  Time: 13:04:02

    stmt(132470704):*/

    SELECT COUNT(TRXSORCE) FROM GPPM.dbo.PM00400 WHERE TRXSORCE = ''

    /*  Date: 10/21/2020  Time: 13:04:02

    stmt(132464376):*/

    SELECT TOP 25 CNTRLNUM,CNTRLTYP,DCSTATUS,DOCTYPE,VENDORID,DOCNUMBR,TRXSORCE,CHEKBKID,DUEDATE,DISCDATE,BCHSOURC,DOCDATE,USERID,DEX_ROW_ID FROM GPPM.dbo.PM00400 WITH ( NOLOCK) WHERE TRXSORCE = '' ORDER BY TRXSORCE ASC ,CNTRLNUM ASC ,DEX_ROW_ID ASC

    /*  Date: 10/21/2020  Time: 13:04:02

    stmt(132470704):*/

    SELECT TOP 25 BACHNUMB,BCHSOURC,VCHNUMWK,VENDORID,DOCNUMBR,DOCTYPE,SOURCDOC,DOCAMNT,DOCDATE,PSTGDATE,VADDCDPR,VADCDTRO,PYMTRMID,TAXSCHID,DUEDATE,DSCDLRAM,DISCDATE,PRCHAMNT,CHRGAMNT,CASHAMNT,CAMCBKID,CDOCNMBR,CAMTDATE,CAMPMTNM,CHEKAMNT,CHAMCBID,CHEKDATE,CAMPYNBR,CRCRDAMT,CCAMPYNM,CHEKNMBR,CARDNAME,CCRCTNUM,CRCARDDT,CURNCYID,CHEKBKID,TRXDSCRN,UN1099AM,TRDISAMT,TAXAMNT,FRTAMNT,TEN99AMNT,MSCCHAMT,PORDNMBR,SHIPMTHD,DISAMTAV,DISTKNAM,APDSTKAM,WROFAMNT,CURTRXAM,TXENGCLD,PMWRKMSG,PMDSTMSG,GSTDSAMT,PGRAMSBJ,PPSAMDED,PPSTAXRT,PSTGSTUS,POSTED,APPLDAMT,VCHRNMBR,CNTRLTYP,MODIFDT,MDFUSRID,POSTEDDT,PTDUSRID,NOTEINDX,BKTFRTAM,BKTMSCAM,BKTPURAM,PCHSCHID,FRTSCHID,MSCSCHID,PRINTED,PRCTDISC,RETNAGAM,ICTRX,ICDISTS,PMICMSGS,Tax_Date,PRCHDATE,CORRCTN,SIMPLIFD,CORRNXST,VCHRNCOR,PMWRKMS2,BNKRCAMT,APLYWITH,Electronic,ECTRX,DocPrinted,TaxInvReqd,BackoutTradeDisc,CBVAT,TEN99TYPE,TEN99BOXNUMBER,Workflow_Status,InvoiceReceiptDate,DEX_ROW_TS,DEX_ROW_ID FROM GPPM.dbo.PM10000 WITH ( NOLOCK) WHERE VENDORID = '' AND DOCNUMBR = '' ORDER BY VENDORID ASC ,DOCNUMBR ASC ,DEX_ROW_ID ASC

    /*  Date: 10/21/2020  Time: 13:05:12

    stmt(132470704):*/

    SELECT TOP 25 BACHNUMB,BCHSOURC,VCHNUMWK,VENDORID,DOCNUMBR,DOCTYPE,SOURCDOC,DOCAMNT,DOCDATE,PSTGDATE,VADDCDPR,VADCDTRO,PYMTRMID,TAXSCHID,DUEDATE,DSCDLRAM,DISCDATE,PRCHAMNT,CHRGAMNT,CASHAMNT,CAMCBKID,CDOCNMBR,CAMTDATE,CAMPMTNM,CHEKAMNT,CHAMCBID,CHEKDATE,CAMPYNBR,CRCRDAMT,CCAMPYNM,CHEKNMBR,CARDNAME,CCRCTNUM,CRCARDDT,CURNCYID,CHEKBKID,TRXDSCRN,UN1099AM,TRDISAMT,TAXAMNT,FRTAMNT,TEN99AMNT,MSCCHAMT,PORDNMBR,SHIPMTHD,DISAMTAV,DISTKNAM,APDSTKAM,WROFAMNT,CURTRXAM,TXENGCLD,PMWRKMSG,PMDSTMSG,GSTDSAMT,PGRAMSBJ,PPSAMDED,PPSTAXRT,PSTGSTUS,POSTED,APPLDAMT,VCHRNMBR,CNTRLTYP,MODIFDT,MDFUSRID,POSTEDDT,PTDUSRID,NOTEINDX,BKTFRTAM,BKTMSCAM,BKTPURAM,PCHSCHID,FRTSCHID,MSCSCHID,PRINTED,PRCTDISC,RETNAGAM,ICTRX,ICDISTS,PMICMSGS,Tax_Date,PRCHDATE,CORRCTN,SIMPLIFD,CORRNXST,VCHRNCOR,PMWRKMS2,BNKRCAMT,APLYWITH,Electronic,ECTRX,DocPrinted,TaxInvReqd,BackoutTradeDisc,CBVAT,TEN99TYPE,TEN99BOXNUMBER,Workflow_Status,InvoiceReceiptDate,DEX_ROW_TS,DEX_ROW_ID FROM GPPM.dbo.PM10000 WITH ( NOLOCK) WHERE VENDORID = '' AND DOCNUMBR = '00069587' ORDER BY VENDORID ASC ,DOCNUMBR ASC ,DEX_ROW_ID ASC

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    28,058 Moderator on at

    Hi Alicia,

    You may have run into a situation with duplicate transactions lying in various tables..

    Have a look at this thread :

    community.dynamics.com/.../exception_class_script_out_of_range-script_cmd_index

    There is a script provided that would help you identify the faulty entries..

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 544 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 450 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans