3,235
Hi,
I'm no more able to create a new company. It hangs at the step 'Creating Company Information'.
Previously I was able to create a new company without any problem.
I'm using GP10 SP5.
I re-installed the application but still the same issue. I changed the server but still the same.
I created a new company ID but still I have the same issue.
Can you please help me?
Thanks.
Hi Richad,
Thanks a lot.
If you have a new DYNAMICS database you will need to correct the note index field in the SY01500 table. Run this script against your comapny database(s).
/*
** FindMaxNoteIndex.SQL
**
** Purpose:
**
** Find the max value of NOTEINDX from all tables.
**
** This script must be run against the company in which the notes are incorrect.
** it will automatically update your SY01500 for you to the correct next note index.
**
** Modified by MRO
*/
if exists (select * from tempdb..sysobjects where name = '##GPSMaxNote')
drop table dbo.##GPSMaxNote
set nocount on
create table ##GPSMaxNote (MaxNoteIndex numeric(19,5) null)
go
declare @cStatement varchar(255) /* Value from the t_cursor */
declare @noteidx numeric(19,5)
declare @database as varchar(5)
set @database = cast(db_name() as varchar(5))
/* Get the tables that have a column name of NOTEINDX. */
declare T_cursor cursor for
select 'declare @NoteIndex numeric(19,5) select @NoteIndex = max(NOTEINDX) from ' + o.name + ' insert ##GPSMaxNote values(@NoteIndex)'
from sysobjects o, syscolumns c
where o.id = c.id
and o.type = 'U'
and c.name = 'NOTEINDX'
/* Ok, we have the list of tables. Now get the max value of NOTEINDX from each table. */
open T_cursor
fetch next from T_cursor into @cStatement
while (@@fetch_status <> -1)
begin
exec (@cStatement)
fetch next from T_cursor into @cStatement
end
deallocate T_cursor
select 'Max Note Index:', max(MaxNoteIndex) from ##GPSMaxNote where MaxNoteIndex is not null
use DYNAMICS
set @noteidx = (select max(MaxNoteIndex) from ##GPSMaxNote where MaxNoteIndex is not null)
update SY01500 set NOTEINDX = (@noteidx + 1.0) where INTERID=@database
set nocount off
Hi,
Finally I found the problem.
I was not able to create a new company because DYNAMICS was corrupted. So, I created a new DYNAMICS and restored our company db. I faced problems with the account format. I discovered that the account format while creating DYNAMICS for some reasons is 45 length and 5 segments rather than 66 length and 10 segments. So, I recreated DYNAMICS with the format 66 length and 10 segments. I re-installed our company
db and every thing went smoothly.
Anyway I thank every body helped me.
Imad Kassoumah.
I was not facing this type of issue previously. Anyway I think this is related to database version compatibility. Have a look on below link.
community.dynamics.com/.../17649.aspx
Hope this helps!!!
Hi,
To resolve the error. "A get/change first operation on table 'ASI_MSTR_Explorer_Favorites' cannot find the table."
Please check the below link.
Hi Soma,
[View:https://community.dynamics.com/cfs-file.ashx/__key/communityserver-discussions-components-files/32/8228.GP10_5F00_Smartlist1.rar]
[View:https://community.dynamics.com/cfs-file.ashx/__key/communityserver-discussions-components-files/32/6567.GP10_5F00_SmartList2.rar]
[View:https://community.dynamics.com/cfs-file.ashx/__key/communityserver-discussions-components-files/32/8182.GP10_5F00_SmartList3.rar]
Thanks.
Hi Soma,
I tried this and I was able to create a new company successfully. Then I restored the company but I faced several problems in GL mainly the account format. I was able to solve them. I faced problems in Smartlist but I was not able to solve.
This is why I think that there is some issues in Dynamics DB.
Thanks.
Imad,
Have you tried to create a new DYNAMICS? If creating a new DYNAMICS and then creating a new company works with no issues then it should be a record in your current DYNAMICS database preventing the company from being registered, this will guide you where to start looking.
Hi Soma,
I mentioned GP10 sp5
thanks.
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...
290,252
Super User 2024 Season 2
#2
Martin Dráb
228,089
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (