Invalid length parameter passed to the LEFT or SUBSTRING function error message in Microsoft Dynamics GP 2015 Sign InShare

Invalid length parameter passed to the LEFT or SUBSTRING function error message in Microsoft Dynamics GP 2015 Sign InShare
TwitterLinkedInFacebookEmailPrintRSS14 Apr 2015 10:00 AM
Hello -

It has been identified that in some scenarios after an upgrade to Microsoft Dynamics GP 2015, the following error is encountered within Microsoft Dynamics GP:

We have seen the above referenced error occur in the following modules: GL, Payables, Payroll and Project. This issue appears to be stemming from missing data in the WF100001 table.

The WfTypeHistBusObjKey is not getting populated for all of the Workflow types which is causing an error in the substring. At this point in time, this issue only seems to appear on databases that have been upgraded. This does not appear to happen on a brand new installation in which the databases themselves (System and Companies) are created brand new on Microsoft Dynamics GP 2015.

Development has been made aware of this issue and it will be addressed in a future release. In the meantime, the workaround is pretty simple. You will need to update the WfTypeHistBusObjKey for the appropriate Workflow_Type_Name that is missing data.

Here are examples of scripts that you may need to run depending on what Workflow_Type_Names have data missing:
update WF100001
set WfTypeHistBusObjKey = 'SY30500~BACHNUMB~BCHSOURC~CREATDDT~TIME1'
where Workflow_Type_Name = 'General Ledger Batch Approval'
update WF100001
set WfTypeHistBusObjKey = 'PM00200~VENDORID'
where Workflow_Type_Name = 'Vendor Approval'
update WF100001
set WfTypeHistBusObjKey = 'PTE30500~PTE_Empl_Expense_Doc_No'
where Workflow_Type_Name = 'Expense Report Approval'
update WF100001
set WfTypeHistBusObjKey = 'PM30100~BACHNUMB~BCHSOURC~CREATDDT~TIME1'
where Workflow_Type_Name = 'Payables Batch Approval'
update WF100001
set WfTypeBusObjKey = 'SY00500~BACHNUMB~BCHSOURC~CREATDDT~TIME1'
where Workflow_Type_Name = 'Receivables Batch Approval'
update WF100001
set WfTypeHistBusObjKey = 'HR30100~EMPLOYID~CREATDDT~CREATETIME'
where Workflow_Type_Name = ‘Employee Skills Approval’
update WF100001
set WfTypeHistBusObjKey = 'DD20100~EMPLOYID'
where Workflow_Type_Name = 'Payroll Direct Deposit Approval'

update WF100001
set WfTypeHistBusObjKey = 'UPR30600~EMPLOYID~CREATDDT~CREATETIME'
where Workflow_Type_Name = 'Employee Profile Approval'

update WF100001
set WfTypeHistBusObjKey = 'UPR30604~EMPLOYID~SEQNUMBR'
where Workflow_Type_Name = 'Payroll W4 Approval'

Thank you!
Sarah

Meet the Author

Sarah Purdy

Comments are closed.