reivilo78
Well Known Member
Hello guys,
So I have this E900 standalone with MSSQL database.
I'm trying to generate the cross reference on them.
First problem that arose is that the cross reference builder batch looked for the specs in the DEMO pathcode which is empty for specs (central objects are only stored "locally" and are not in DEMO pathcode, probably to save some space for the already huge installation program)
So what I did is I copied all the tables from spec_master ("local" specs) to JDEVL (central objects for DEMO pathcode), since I couldn't find a way to make the cross reference batch read in spec_master (the tables have an added "MASTER" after their name so I dont think it is possible to make OCM redirections to them, but maybe you guys have a better idea ?).
here are the SQL commands I used :
insert into jdevl.dbo.F98710 select * from SPEC_MASTER.DBO.F98710MASTER;
insert into jdevl.dbo.F98711 select * from SPEC_MASTER.DBO.F98711MASTER;
insert into jdevl.dbo.F98712 select * from SPEC_MASTER.DBO.F98712MASTER;
insert into jdevl.dbo.F98713 select * from SPEC_MASTER.DBO.F98713MASTER;
insert into jdevl.dbo.F98720 select * from SPEC_MASTER.DBO.F98720MASTER;
insert into jdevl.dbo.F98740 select * from SPEC_MASTER.DBO.F98740MASTER;
insert into jdevl.dbo.F98741 select * from SPEC_MASTER.DBO.F98741MASTER;
insert into jdevl.dbo.F98743 select * from SPEC_MASTER.DBO.F98743MASTER;
insert into jdevl.dbo.F98745 select * from SPEC_MASTER.DBO.F98745MASTER;
insert into jdevl.dbo.F98750 select * from SPEC_MASTER.DBO.F98750MASTER;
insert into jdevl.dbo.F98751 select * from SPEC_MASTER.DBO.F98751MASTER;
insert into jdevl.dbo.F98752 select * from SPEC_MASTER.DBO.F98752MASTER;
insert into jdevl.dbo.F98753 select * from SPEC_MASTER.DBO.F98753MASTER;
insert into jdevl.dbo.F98760 select * from SPEC_MASTER.DBO.F98760MASTER;
insert into jdevl.dbo.F98761 select * from SPEC_MASTER.DBO.F98761MASTER;
insert into jdevl.dbo.F98762 select * from SPEC_MASTER.DBO.F98762MASTER;
insert into jdevl.dbo.F98770 select * from SPEC_MASTER.DBO.F98770MASTER;
After that, I successfully ran the cross reference batch on Business View Object. it did create the cross reference entries.
But when i tried to run the cross reference batch on applications, I had some errors in log after a while :
6236/2484 WRK:Starting jdeCallObject Mon Sep 12 22:52:23.859002 Jdbodbc.c6904
ODB0000164 - STMT:00 [42000][1105][2] [Microsoft][SQL Native Client][SQL Server]Could not allocate space for object 'DBO.F980021'.'F980021_2' in database 'JDEVL' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding ad
Do you guys have any idea on how to solve this ?
Using SQL Manager I looked at the maximum size of the database files and it's way above the current size so I don't really understand the problem.
So I have this E900 standalone with MSSQL database.
I'm trying to generate the cross reference on them.
First problem that arose is that the cross reference builder batch looked for the specs in the DEMO pathcode which is empty for specs (central objects are only stored "locally" and are not in DEMO pathcode, probably to save some space for the already huge installation program)
So what I did is I copied all the tables from spec_master ("local" specs) to JDEVL (central objects for DEMO pathcode), since I couldn't find a way to make the cross reference batch read in spec_master (the tables have an added "MASTER" after their name so I dont think it is possible to make OCM redirections to them, but maybe you guys have a better idea ?).
here are the SQL commands I used :
insert into jdevl.dbo.F98710 select * from SPEC_MASTER.DBO.F98710MASTER;
insert into jdevl.dbo.F98711 select * from SPEC_MASTER.DBO.F98711MASTER;
insert into jdevl.dbo.F98712 select * from SPEC_MASTER.DBO.F98712MASTER;
insert into jdevl.dbo.F98713 select * from SPEC_MASTER.DBO.F98713MASTER;
insert into jdevl.dbo.F98720 select * from SPEC_MASTER.DBO.F98720MASTER;
insert into jdevl.dbo.F98740 select * from SPEC_MASTER.DBO.F98740MASTER;
insert into jdevl.dbo.F98741 select * from SPEC_MASTER.DBO.F98741MASTER;
insert into jdevl.dbo.F98743 select * from SPEC_MASTER.DBO.F98743MASTER;
insert into jdevl.dbo.F98745 select * from SPEC_MASTER.DBO.F98745MASTER;
insert into jdevl.dbo.F98750 select * from SPEC_MASTER.DBO.F98750MASTER;
insert into jdevl.dbo.F98751 select * from SPEC_MASTER.DBO.F98751MASTER;
insert into jdevl.dbo.F98752 select * from SPEC_MASTER.DBO.F98752MASTER;
insert into jdevl.dbo.F98753 select * from SPEC_MASTER.DBO.F98753MASTER;
insert into jdevl.dbo.F98760 select * from SPEC_MASTER.DBO.F98760MASTER;
insert into jdevl.dbo.F98761 select * from SPEC_MASTER.DBO.F98761MASTER;
insert into jdevl.dbo.F98762 select * from SPEC_MASTER.DBO.F98762MASTER;
insert into jdevl.dbo.F98770 select * from SPEC_MASTER.DBO.F98770MASTER;
After that, I successfully ran the cross reference batch on Business View Object. it did create the cross reference entries.
But when i tried to run the cross reference batch on applications, I had some errors in log after a while :
6236/2484 WRK:Starting jdeCallObject Mon Sep 12 22:52:23.859002 Jdbodbc.c6904
ODB0000164 - STMT:00 [42000][1105][2] [Microsoft][SQL Native Client][SQL Server]Could not allocate space for object 'DBO.F980021'.'F980021_2' in database 'JDEVL' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding ad
Do you guys have any idea on how to solve this ?
Using SQL Manager I looked at the maximum size of the database files and it's way above the current size so I don't really understand the problem.