90
I have two issue in analytical accounting module after install GP10 SP5,
(1) when open open Transactionà Financial à Edit analysis , insert the year and insert the journal screen hung without any result and if to try to use lookup the below error appear . and that's happen on one company the other companies work without any problem,
(2) any user have "dot or space" in user name couldn't open Trx dim code in analytical
Thanks
*This post is locked for comments
Dear Mohammad
I already made a trace on the function mentioned in first problem
and it gave me all procedures and code running when i click that button
i ran it in SQL studio with the same parameters and it stopped in:
BEGIN DECLARE @stored_proc_name char(44) DECLARE @retstat int set nocount on SELECT @stored_proc_name = 'BTR.dbo.aagCreateRecordsInaaGLWorkForJrnlNum' EXEC @retstat = @stored_proc_name 15 SELECT @retstat set nocount on END
go
And when select from aag10001 on the aaGLWorkHdrID
aag10001.AAGLWorkDistID keep incrementing by negative value for ever - until i stop running code
I am looking forward to your advise
Regards
tamer
----------------------------- Profiler traced code
SELECT TOP 25 aaGLHdrID,JRNENTRY,RCTRXSEQ,YEAR1,aaTRXType,aaGLTRXSource,aaTRXSource,GLPOSTDT,DEX_ROW_ID FROM BTR.dbo.AAG30000 WHERE (JRNENTRY = 60) ORDER BY aaGLHdrID ASC
go
SELECT TOP 25 aaGLHdrID,aaGLDistID,INTERID,CorrespondingUnit,ACTINDX,ACCTTYPE,aaBrowseType,DECPLACS,DEBITAMT,CRDTAMNT,ORDBTAMT,ORCRDAMT,CURNCYID,CURRNIDX,RATETPID,EXGTBLID,XCHGRATE,EXCHDATE,TIME1,RTCLCMTD,DENXRATE,MCTRXSTT,SEQNUMBR,aaCustID,aaVendID,aaSiteID,aaItemID,aaCopyStatus,SOURCDOC,aaChangeDate,aaChangeTime,DEX_ROW_ID FROM BTR.dbo.AAG30001 WHERE (aaGLHdrID = 15) ORDER BY aaGLHdrID ASC ,aaGLDistID ASC
go
exec DYNAMICS.dbo.zDP_SY02100SS_1 3,3180,1,0
go
BEGIN DECLARE @stored_proc_name char(31) DECLARE @retstat int DECLARE @param3 smallint set nocount on SELECT @param3 = 0 SELECT @stored_proc_name = 'BTR.dbo.aagVerifyJournalAndYear' EXEC @retstat = @stored_proc_name 60, 2010, @param3 OUT SELECT @retstat, @param3 set nocount on END
go
SELECT TOP 25 OPENYEAR,JRNENTRY,RCTRXSEQ,SOURCDOC,REFRENCE,DSCRIPTN,TRXDATE,TRXSORCE,ACTINDX,POLLDTRX,LASTUSER,LSTDTEDT,USWHPSTD,ORGNTSRC,ORGNATYP,QKOFSET,SERIES,ORTRXTYP,ORCTRNUM,ORMSTRID,ORMSTRNM,ORDOCNUM,ORPSTDDT,ORTRXSRC,OrigDTASeries,OrigSeqNum,SEQNUMBR,DTA_GL_Status,DTA_Index,CURNCYID,CURRNIDX,RATETPID,EXGTBLID,XCHGRATE,EXCHDATE,TIME1,RTCLCMTD,NOTEINDX,ICTRX,ORCOMID,ORIGINJE,PERIODID,CRDTAMNT,DEBITAMT,ORCRDAMT,ORDBTAMT,DOCDATE,PSTGNMBR,PPSGNMBR,DENXRATE,MCTRXSTT,CorrespondingUnit,VOIDED,Back_Out_JE,Back_Out_JE_Year,Correcting_JE,Correcting_JE_Year,Original_JE,Original_JE_Seq_Num,Original_JE_Year,DEX_ROW_TS,DEX_ROW_ID FROM BTR.dbo.GL20000 WHERE (VOIDED = 1 and JRNENTRY = 60) ORDER BY JRNENTRY ASC ,RCTRXSEQ ASC ,ACTINDX ASC ,TRXDATE ASC ,PERIODID ASC ,DEX_ROW_ID ASC
go
exec DYNAMICS.dbo.zDP_SY02100SS_1 3,3180,1,0
go
BEGIN DECLARE @stored_proc_name char(21) DECLARE @retstat int DECLARE @param1 int DECLARE @param2 char(13) DECLARE @param3 datetime DECLARE @param4 int DECLARE @param5 smallint DECLARE @param6 char(13) DECLARE @param7 smallint DECLARE @param8 smallint set nocount on SELECT @param1 = 60 SELECT @param2 = '' SELECT @param3 = '1900.01.01' SELECT @param4 = 0 SELECT @param5 = 0 SELECT @param6 = '' SELECT @param7 = 0 SELECT @param8 = 2 SELECT @stored_proc_name = 'BTR.dbo.aagGetGLHdrID' EXEC @retstat = @stored_proc_name @param1 OUT, @param2 OUT, @param3 OUT, @param4 OUT, @param5 OUT, @param6 OUT, @param7 OUT, @param8 OUT SELECT @retstat, @param1, @param2, @param3, @param4, @param5, @param6, @param7, @param8 set nocount on END
go
SELECT TOP 25 aaGLHdrID,JRNENTRY,RCTRXSEQ,YEAR1,aaTRXType,aaGLTRXSource,aaTRXSource,GLPOSTDT,DEX_ROW_ID FROM BTR.dbo.AAG30000 WHERE (JRNENTRY = 60) AND aaGLHdrID = 15 ORDER BY aaGLHdrID ASC
go
exec DYNAMICS.dbo.zDP_SY02100SS_1 3,3180,1,0
go
BEGIN DECLARE @stored_proc_name char(40) DECLARE @retstat int DECLARE @param2 tinyint set nocount on SELECT @param2 = 0 SELECT @stored_proc_name = 'BTR.dbo.aagAreAllAccntsDeLinkedFromClass' EXEC @retstat = @stored_proc_name 15, @param2 OUT SELECT @retstat, @param2 set nocount on END
go
exec BTR.dbo.zDP_SY00700SS_1 'aaGLAdjustmentsEntry0'
go
exec DYNAMICS.dbo.zDP_SY01500SS_1 3
go
select 504,c.name,c.description,c.definition from master.dbo.syscharsets c where c.id = convert(tinyint, databasepropertyex ( db_name() , 'sqlcharset')) set ansi_nulls off set ansi_padding off set ansi_warnings off set concat_null_yields_null off set quoted_identifier off
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
BEGIN SET DATEFORMAT ymd
SET NOCOUNT ON
SET CURSOR_CLOSE_ON_COMMIT OFF
SET ANSI_NULLS ON
SET ANSI_WARNINGS OFF
SET ANSI_NULL_DFLT_ON ON
SET ANSI_PADDING ON
SET NUMERIC_ROUNDABORT OFF
END
go
use BTR
go
set nocount on select count(*) from AAG20001 where aaSubLedgerHdrID = 0 and aaBrowseType = 3 set nocount off
go
exec BTR.dbo.zDP_SY40101F_3 0,-32768,0,32767
go
exec DYNAMICS.dbo.zDP_SY01500SS_1 3
go
select 504,c.name,c.description,c.definition from master.dbo.syscharsets c where c.id = convert(tinyint, databasepropertyex ( db_name() , 'sqlcharset')) set ansi_nulls off set ansi_padding off set ansi_warnings off set concat_null_yields_null off set quoted_identifier off
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
BEGIN SET DATEFORMAT ymd
SET NOCOUNT ON
SET CURSOR_CLOSE_ON_COMMIT OFF
SET ANSI_NULLS ON
SET ANSI_WARNINGS OFF
SET ANSI_NULL_DFLT_ON ON
SET ANSI_PADDING ON
SET NUMERIC_ROUNDABORT OFF
END
go
use BTR
go
set nocount on select count(*) from AAG10001 where aaGLWorkHdrID = 0 and aaGLWorkDistID > 0 and aaBrowseType <> 0 set nocount off
exec ##zDP_2344258L_1 NULL,NULL,NULL,NULL,NULL,NULL
go
exec ##zDP_2504258L_1 NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
go
exec DYNAMICS.dbo.zDP_SY01500SS_1 3
go
select 504,c.name,c.description,c.definition from master.dbo.syscharsets c where c.id = convert(tinyint, databasepropertyex ( db_name() , 'sqlcharset')) set ansi_nulls off set ansi_padding off set ansi_warnings off set concat_null_yields_null off set quoted_identifier off
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
BEGIN SET DATEFORMAT ymd
SET NOCOUNT ON
SET CURSOR_CLOSE_ON_COMMIT OFF
SET ANSI_NULLS ON
SET ANSI_WARNINGS OFF
SET ANSI_NULL_DFLT_ON ON
SET ANSI_PADDING ON
SET NUMERIC_ROUNDABORT OFF
END
go
use BTR
go
set nocount on delete from BTR.dbo.AAG3000E where aaGLWorkHdrID = 0 set nocount off
go
exec DYNAMICS.dbo.zDP_SY01500SS_1 3
go
select 504,c.name,c.description,c.definition from master.dbo.syscharsets c where c.id = convert(tinyint, databasepropertyex ( db_name() , 'sqlcharset')) set ansi_nulls off set ansi_padding off set ansi_warnings off set concat_null_yields_null off set quoted_identifier off
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
BEGIN SET DATEFORMAT ymd
SET NOCOUNT ON
SET CURSOR_CLOSE_ON_COMMIT OFF
SET ANSI_NULLS ON
SET ANSI_WARNINGS OFF
SET ANSI_NULL_DFLT_ON ON
SET ANSI_PADDING ON
SET NUMERIC_ROUNDABORT OFF
END
go
use BTR
go
set nocount on select count(*) from BTR.dbo.AAG3000E where aaGLWorkHdrID = 0 set nocount off
go
exec DYNAMICS.dbo.zDP_SY02100SS_1 3,3180,1,0
go
BEGIN DECLARE @stored_proc_name char(40) DECLARE @retstat int set nocount on SELECT @stored_proc_name = 'BTR.dbo.aagDeleteAdjustmentTRXFromGLWork' EXEC @retstat = @stored_proc_name SELECT @retstat set nocount on END
go
exec BTR.dbo.zDP_SY00700SS_1 'aaGLAdjustmentsEntry0'
go
exec DYNAMICS.dbo.zDP_SY01500SS_1 3
go
select 504,c.name,c.description,c.definition from master.dbo.syscharsets c where c.id = convert(tinyint, databasepropertyex ( db_name() , 'sqlcharset')) set ansi_nulls off set ansi_padding off set ansi_warnings off set concat_null_yields_null off set quoted_identifier off
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
BEGIN SET DATEFORMAT ymd
SET NOCOUNT ON
SET CURSOR_CLOSE_ON_COMMIT OFF
SET ANSI_NULLS ON
SET ANSI_WARNINGS OFF
SET ANSI_NULL_DFLT_ON ON
SET ANSI_PADDING ON
SET NUMERIC_ROUNDABORT OFF
END
go
use BTR
go
set nocount on select count(*) from AAG20001 where aaSubLedgerHdrID = 0 and aaBrowseType = 3 set nocount off
go
exec BTR.dbo.zDP_SY40101F_3 0,-32768,0,32767
go
exec DYNAMICS.dbo.zDP_SY02100SS_1 3,3180,3,0
go
BEGIN DECLARE @stored_proc_name char(44) DECLARE @retstat int set nocount on SELECT @stored_proc_name = 'BTR.dbo.aagCreateRecordsInaaGLWorkForJrnlNum' EXEC @retstat = @stored_proc_name 15 SELECT @retstat set nocount on END
go
For your first error, you will need to perform further research by running SQL Server profiler and getting where exactly your process hangs, for your second issue this might be possible as analytical accounting is creating temp stored procedures and table at runtime over your tempdb that includes the username who created the operation, and having "." in user name might identify the owner name with unknown name and might cause this issue, I will sone tests on this subject and get back to you.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (