Share
ReportWe have recently in the process of Upgrade of ERP from AX 2009 to AX 2012 R3.
Code upgrade is done and after Data upgrade, we have faced below mentioned problem on Time Sheet (Enterprise portal).
Issue: When user tries to create the TS header and then TS Line on EP portal, user is able to input values. But when user clicks on button (SAVE / update), it gives below error (refer error message received):
Observation: In the below query, system is performing cross join on two tables which has lacs of records and hence resultant record set is huge which leads to either time out or below error. If someone can help here to understand where this CROSS JOIN (Refer end of SQL statement) is performed in portal / dataset / AX AOD so that this could be resolved.
It would be of great help if someone can help us in resolving the problem as our Go-Live is very nearby.
Thanks in advance.
Error message received on EP:
Cannot select a record in Timesheet line (TSTimesheetLine). Project: IND-000068-001, NB-L3. The SQL database has issued an error.SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]Could not complete cursor operation because the table schema changed after the cursor was declared.
SQL statement:
SELECT T1.ACTIVITYCOMPLETE,T1.ACTIVITYNUMBER,T1.ACTIVITYREMAINING,
T1.CATEGORYID,T1.WORKER,T1.LINEPROPERTYID,T1.PROJID,T1.RECID,
T1.RECVERSION,T1.TIMESHEETNBR,T1.WRKCTRID,T1.PROJECTDATAAREAID,
T2.PROJGROUPID,T2.PROJID,T2.NAME,T2.PROJLEDGERPOSTING,T2.CREATED,
T2.STARTDATE,T2.ENDDATE,T2.CUSTACCOUNT,T2.DLVNAME,T2.DEL_DLVADDR,
T2.DEL_DIMENSION,T2.DEL_DIMENSION2_,T2.DEL_DIMENSION3_,T2.DEL_DIMENSION4_,
T2.DEL_DIMENSION5_,T2.DEL_DIMENSION6_,T2.DEL_DIMENSION7_,T2.DEL_DIMENSION8_,
T2.DEL_DIMENSION9_,T2.DEL_RESPONSIBLESALES,T2.PROJINVOICEPROJID,T2.DEL_DLVZIPCODE,
T2.DEL_DLVCOUNTY,T2.DEL_DLVCOUNTRYREGIONID,T2.DEL_DLVSTATE,T2.DEL_RESPONSIBLE,
T2.EMAIL,T2.DEL_URL,T2.PARENTID,T2.HEADER,T2.TAXGROUPID,T2.FORMAT,T2.CHECKBUDGET,
T2.SORTINGID,T2.SORTINGID2_,T2.SORTINGID3_,T2.SYNCLASTTRANSID,T2.STATUS,
T2.WIPPROJECT,T2.TYPE,T2.DEL_RESPONSIBLEFINANCIAL,T2.TEMPLATE,T2.DEL_DELIVERYCITY,
T2.DEL_DELIVERYSTREET,T2.VALIDATEPROJCATEGORY,T2.PROJLINEPROPERTYSEARCH,
T2.DEL_PRINTMODULETYPE,T2.DELIVERYLOCATION,T2.DEFAULTDIMENSION,T2.REQUIREACTIVITYHOURTRX,
T2.REQUIREACTIVITYEXPENSETRX,T2.REQUIREACTIVITYITEMTRX,T2.REQUIREACTIVITYHOURFORECAST,
T2.REQUIREACTIVITYEXPENSEFORECAST,T2.REQUIREACTIVITYITEMFORECAST,T2.USEBUDGETING,
T2.USEALTERNATEPROJECT,T2.PROJPRICEGROUP,T2.PROJBUDGETOVERRUNOPTION,T2.SYNCENTITYID,
T2.SYNCVERSION,T2.PROJBUDGETARYCONTROLON,T2.SYNCCREATEDBYEXTERNAL,T2.ASSETID,
T2.PROJECTEDSTARTDATE,T2.PROJECTEDENDDATE,T2.EXTENSIONDATE,T2.ALTERNATEBUDGETPROJECT,
T2.PROJBUDGETINTERVAL,T2.TIMEPOSTDETAILSUMMARY,T2.MINTIMEINCREMENT,T2.PROJCARRYFORWARDREMAININGBUDGET,
T2.PROJCARRYFORWARDNEGATIVEBUDGET,T2.WORKERRESPONSIBLEFINANCIAL,T2.WORKERRESPONSIBLE,
T2.WORKERRESPONSIBLESALES,T2.BANKDOCUMENTTYPE,T2.JOBID,T2.JOBPAYTYPE,T2.DEL_STCNUMBER_IN,
T2.DEL_TIN_IN,T2.DEL_SALESTAXREGISTRATIONNUMBER_IN,T2.DEL_IECNUMBER_IN,T2.DEL_ECCNUMBER_IN,
T2.DEL_TAN_IN,T2.PSAPROJTASK,T2.DEL_PSAPDSUIDPROJECT,T2.DEL_PSAPDSUIDTASK,T2.DEL_PSAPDSWBSCODE,
T2.DEL_PSAPROFILE,T2.DEL_PSAPURCHID,T2.PSAUNITID,T2.PSATIMEMEASURE,T2.PSATRACKCOST,
T2.DEL_PSAPDSIDTASK,T2.PSAFORECASTMODELID,T2.DEL_PSACAPAMT,T2.PSAINVOICEMETHOD,
T2.PSAREADYFORINVOICING,T2.PSADOINVOICECOST,T2.PSAPROJSTATUS,T2.DEL_PSATASKID,
T2.PSAFORECASTMODELIDEXTERNAL,T2.PSAPHONE,T2.PSATELEFAX,T2.PSAPREQITEMVALIDATE,
T2.PSAPREQHOURVALIDATE,T2.PSAPREQCONTROL,T2.DEL_PSAACTUALLABORCOST,T2.PSASCHEDMILESTONE,
T2.PSASCHEDSTARTDATE,T2.PSASCHEDENDDATE,T2.PSASCHEDDURATION,T2.PSASCHEDUSEDURATION,
T2.PSASCHEDCALENDARID,T2.PSASCHEDIGNORECALENDAR,T2.PSASCHEDCONSTRAINTTYPE,T2.PSASCHEDCONSTRAINTDATE,
T2.PSASCHEDSCHEDULED,T2.DEL_PSAARCHITECT,T2.PSASCHEDEFFORT,T2.PSASCHEDFROMTIME,T2.PSASCHEDTOTIME,
T2.PSASCHEDDEFAULTDATE,T2.DEL_PSAUNMATCHEDPREBILL,T2.DEL_PSAUNMATCHEDCOST,T2.DEL_PSAPWP,
T2.DEL_PSAOVERVENDPWP,T2.DEL_PSAPROJBALANCE,T2.DEL_SERVICEID,T2.PSARESSCHEDSTATUS,T2.COMPLETESCHEDULED,
T2.DEL_PSAPROJREQUESTID,T2.OCIP,T2.CERTIFIEDPAYROLL,T2.OCIPGL,T2.TECSIGNEDCONTRACT,T2.TECUNSIGNEDCONTRACT,
T2.TECEMAILPROPOSAL,T2.TECCUTOFFDATE,T2.TECFREEPILOTPTDPROJECTTYPE,T2.TECPIDNUMBER,T2.TECGEOGRAPHYOFDELIVERY,
T2.TECPAYMTERMID,T2.TECAVPCOMPANYACCOUNT,T2.TECGMCOMPANYACCOUNT,T2.TECPLCOMPANYACCOUNT,T2.TECSMCOMPANYACCOUNT,
T2.TECPMCOMPANYACCOUNT,T2.TECPCCOMPANYACCOUNT,T2.TECAVPUSERID,T2.TECGMUSERID,T2.TECPLUSERID,T2.TECCONTACTPERSONID,
T2.TECSTATUTORYPROJECTGROUP,T2.TECGMUSERID1,T2.TECPROJECTMANAGERUSERID,T2.TECVERSION,T2.TECOVERRULESUBMITDATEVALIDATION,
T2.DEL_OVERRULESUBMITDATEVALIDATION,T2.EVSWFLPROJECTREF,T2.EVSOPPORTUNITYID,T2.EVSENDCUSTACCOUNT,
T2.EVSPOCOMPANYACCOUNT,T2.EVSPOUSERID,T2.EVSCLIENTINDUSTRY,T2.EVSADDRESSREFRECID,T2.EVSADDRESSREFTABLEID,
T2.EVSBELOWPRICINGSHEET,T2.EVSPROJECTFINISHEDDATE,T2.EVSONSITEPROJECT,T2.EVSCOSTPERC,T2.EVSPROJINITREQUESTNO,
T2.EVSDUPLICATEOPPORTUNITY,T2.EVSPROJTODEFINE,T2.EVSPARENTPROJID,T2.EVSWFPIREPORTS,T2.EVSPMPROJCLOSURE,
T2.EVSPTCMARGIN,T2.EVSCLIENTFBINITIATED,T2.EVSWFLREF,T2.EVSPROJECTOFFICERGROUP,T2.PROJBUDGETMANAGEMENT,
T2.DEL_PSAISPSAPROJECT,T2.EVSLEDGERDIMENSION,T2.EVSCONTACTEMAILTO,T2.EVSACCOUNTTYPE,T2.EVSCOMPANYID,T2.MODIFIEDDATETIME,
T2.MODIFIEDBY,T2.CREATEDDATETIME,T2.CREATEDBY,T2.RECVERSION,T2.PARTITION,T2.RECID,T2.PSANOTES,T2.TECREMARKS,
T2.EVSAMENDMENTREMARKS FROM TSTIMESHEETLINE T1 CROSS JOIN PROJTABLE T2
WHERE (((T1.PARTITION=?) AND (T1.DATAAREAID=?)) AND (T1.RECID=?)) AND ((T2.PARTITION=?) AND (T2.DATAAREAID=?)) ORDER BY T1.TIMESHEETNBR
*This post is locked for comments
I have the same question (0)
All responses (
Answers (
5
