8.12 Central Objects file configuration

If anyone is running 8.12 on SQL Server would you mind running the following query and posting the results? It is important that only those who have not modified their database file configurations post results.

<font class="small">Code:</font><hr /><pre>
use jde_pd812
go
sp_helpfile
go </pre><hr />


Also, if possible, the following section of a file named I:\JDEdwards\E812\MSSQL\ce_create_temp_sps.sql?


<font class="small">Code:</font><hr /><pre> SET @create_string = 'CREATE DATABASE JDE_'+@upathcode+' ON'
SET @create_string = @create_string+ ' ( NAME = ''JDE_'+@upathcode+'_Data1'','
SET @create_string = @create_string+ ' FILENAME = '''+@sql_path+'\JDE_'+@upathcode+'data1.mdf'','
SET @create_string = @create_string+ ' SIZE = 1500,'
SET @create_string = @create_string+ ' FILEGROWTH = 0 ),'
SET @create_string = @create_string+ ' ( NAME = ''JDE_'+@upathcode+'_Data2'','
SET @create_string = @create_string+ ' FILENAME = '''+@sql_path+'\JDE_'+@upathcode+'data2.mdf'','
SET @create_string = @create_string+ ' SIZE = 1500,'
SET @create_string = @create_string+ ' FILEGROWTH = 0 ),'
SET @create_string = @create_string+ ' ( NAME = ''JDE_'+@upathcode+'_Data3'','
SET @create_string = @create_string+ ' FILENAME = '''+@sql_path+'\JDE_'+@upathcode+'data3.mdf'','
SET @create_string = @create_string+ ' SIZE = 500,'
SET @create_string = @create_string+ ' MAXSIZE = 2000,'
SET @create_string = @create_string+ ' FILEGROWTH = 50 )'
SET @create_string = @create_string+ ' LOG ON'
SET @create_string = @create_string+ ' ( NAME = ''JDE_'+@upathcode+'_Log'','
SET @create_string = @create_string+ ' FILENAME = '''+@sql_path+'\JDE_'+@upathcode+'log.ldf'','
SET @create_string = @create_string+ ' SIZE = 200,'
SET @create_string = @create_string+ ' MAXSIZE = 1000,'
SET @create_string = @create_string+ ' FILEGROWTH = 5 )'
</pre><hr />

<font class="small">Code:</font><hr /><pre>JDE_PD812_Data1 1 F:\JDE_Data\MSSQL\JDE_PD812data1.MDF PRIMARY 1536000 KB Unlimited 80 KB data only
JDE_PD812_Log 2 E:\JDE_Logs\JDE_PD812log.ldf NULL 1909760 KB Unlimited 5120 KB log only
JDE_PD812_Data2 3 F:\JDE_Data\MSSQL\JDE_PD812data2.NDF PRIMARY 1536000 KB Unlimited 0 KB data only
JDE_PD812_Data3 4 F:\JDE_Data\MSSQL\JDE_PD812data3.NDF PRIMARY 2048000 KB Unlimited 51200 KB data only
</pre><hr />

Sorry, I just saw your edit, and obviously I've changed the default file locations, and set them for unlimited growth. Unfortunately, I'm not sure about the other code snippet you would like run. Without the variables being declared and set, that snippet just produces errors:

<font class="small">Code:</font><hr /><pre>Msg 137, Level 15, State 2, Line 1
Must declare the scalar variable "@upathcode".
Msg 137, Level 15, State 2, Line 2
Must declare the scalar variable "@create_string".
Msg 137, Level 15, State 2, Line 3
Must declare the scalar variable "@create_string".
Msg 137, Level 15, State 2, Line 4
Must declare the scalar variable "@create_string".
Msg 137, Level 15, State 2, Line 5
Must declare the scalar variable "@create_string".
Msg 137, Level 15, State 2, Line 6
Must declare the scalar variable "@create_string".
Msg 137, Level 15, State 2, Line 7
Must declare the scalar variable "@create_string".
Msg 137, Level 15, State 2, Line 8
Must declare the scalar variable "@create_string".
Msg 137, Level 15, State 2, Line 9
Must declare the scalar variable "@create_string".
Msg 137, Level 15, State 2, Line 10
Must declare the scalar variable "@create_string".
Msg 137, Level 15, State 2, Line 11
Must declare the scalar variable "@create_string".
Msg 137, Level 15, State 2, Line 12
Must declare the scalar variable "@create_string".
Msg 137, Level 15, State 2, Line 13
Must declare the scalar variable "@create_string".
Msg 137, Level 15, State 2, Line 14
Must declare the scalar variable "@create_string".
Msg 137, Level 15, State 2, Line 15
Must declare the scalar variable "@create_string".
Msg 137, Level 15, State 2, Line 16
Must declare the scalar variable "@create_string".
Msg 137, Level 15, State 2, Line 17
Must declare the scalar variable "@create_string".
Msg 137, Level 15, State 2, Line 18
Must declare the scalar variable "@create_string".
Msg 137, Level 15, State 2, Line 19
Must declare the scalar variable "@create_string".
Msg 137, Level 15, State 2, Line 20
Must declare the scalar variable "@create_string".
</pre><hr />

Now it clearly is used by the Platform Pack installation as the script to create the default Central Objects database files, and is tied to a whole series of batch files and SQL scripts, as I'm sure you know.

So I'm a little confused as to what you were trying to test. Was there more of that total script you wanted to test?

Here ya go !

[ QUOTE ]

JDE_PD812_Data1 1 E:\MSSQL.1\MSSQL\Data\MSSQL\JDE_PD812data1.MDF PRIMARY 1536000 KB Unlimited 51200 KB data only
JDE_PD812_Log 2 E:\MSSQL.1\MSSQL\Data\MSSQL\JDE_PD812LOG.LDF NULL 1909760 KB Unlimited 5120 KB log only
JDE_PD812_Data2 3 E:\MSSQL.1\MSSQL\Data\MSSQL\JDE_PD812data2.NDF PRIMARY 1536000 KB Unlimited 51200 KB data only
JDE_PD812_Data3 4 E:\MSSQL.1\MSSQL\Data\MSSQL\JDE_PD812data3.NDF PRIMARY 2048000 KB Unlimited 51200 KB data only


[/ QUOTE ]

I might have changed the growth numbers so that the files can grow (I think some of them were set NOT to grow - and when I patched to fixcurrent, I got failures - so I changed the files...)

and here is ce_create_temp_sps.sql which is untouched.

[ QUOTE ]

CREATE PROC ce_ENV_DB_SQLSRVR
@sql_path sysname,
@uenv sysname
AS
DECLARE @create_string varchar(4000)
DECLARE @alter_string varchar(4000)
DECLARE @bError bit

SET @bError = 0

SET @create_string = 'CREATE DATABASE JDE_'+@uenv+' ON'
SET @create_string = @create_string+ ' ( NAME = ''JDE_'+@uenv+'_Data'','
SET @create_string = @create_string+ ' FILENAME = '''+@sql_path+'\JDE_'+@uenv+'data.mdf'','
SET @create_string = @create_string+ ' SIZE = 800,'
SET @create_string = @create_string+ ' MAXSIZE = UNLIMITED,'
SET @create_string = @create_string+ ' FILEGROWTH = 100 )'
SET @create_string = @create_string+ ' LOG ON'
SET @create_string = @create_string+ ' ( NAME = ''JDE_'+@uenv+'_Log'','
SET @create_string = @create_string+ ' FILENAME = '''+@sql_path+'\JDE_'+@uenv+'log.ldf'','
SET @create_string = @create_string+ ' SIZE = 500,'
SET @create_string = @create_string+ ' MAXSIZE = UNLIMITED,'
SET @create_string = @create_string+ ' FILEGROWTH = 50 )'

PRINT ' '
PRINT 'use master'
EXEC ('use master')
PRINT @create_string
EXEC (@create_string)
IF @@ERROR <> 0
BEGIN
SET @bError = 1
END

SET @alter_string = 'ALTER DATABASE JDE_'+@uenv+' SET RECOVERY SIMPLE'
PRINT ' '
PRINT @alter_string
EXEC (@alter_string)
IF @@ERROR <> 0
BEGIN
SET @bError = 1
END

IF (@bError = 1)
BEGIN
PRINT ' '
RAISERROR ('Database Create Failed: %s',18,1,@uenv)
END
GO

CREATE PROC ce_PC_DB_SQLSRVR
@sql_path sysname,
@upathcode sysname
AS
DECLARE @create_string varchar(4000)
DECLARE @alter_string varchar(4000)
DECLARE @bError bit

SET @bError = 0

SET @create_string = 'CREATE DATABASE JDE_'+@upathcode+' ON'
SET @create_string = @create_string+ ' ( NAME = ''JDE_'+@upathcode+'_Data1'','
SET @create_string = @create_string+ ' FILENAME = '''+@sql_path+'\JDE_'+@upathcode+'data1.mdf'','
SET @create_string = @create_string+ ' SIZE = 1500,'
SET @create_string = @create_string+ ' FILEGROWTH = 0 ),'
SET @create_string = @create_string+ ' ( NAME = ''JDE_'+@upathcode+'_Data2'','
SET @create_string = @create_string+ ' FILENAME = '''+@sql_path+'\JDE_'+@upathcode+'data2.mdf'','
SET @create_string = @create_string+ ' SIZE = 1500,'
SET @create_string = @create_string+ ' FILEGROWTH = 0 ),'
SET @create_string = @create_string+ ' ( NAME = ''JDE_'+@upathcode+'_Data3'','
SET @create_string = @create_string+ ' FILENAME = '''+@sql_path+'\JDE_'+@upathcode+'data3.mdf'','
SET @create_string = @create_string+ ' SIZE = 500,'
SET @create_string = @create_string+ ' MAXSIZE = 2000,'
SET @create_string = @create_string+ ' FILEGROWTH = 50 )'
SET @create_string = @create_string+ ' LOG ON'
SET @create_string = @create_string+ ' ( NAME = ''JDE_'+@upathcode+'_Log'','
SET @create_string = @create_string+ ' FILENAME = '''+@sql_path+'\JDE_'+@upathcode+'log.ldf'','
SET @create_string = @create_string+ ' SIZE = 200,'
SET @create_string = @create_string+ ' MAXSIZE = 1000,'
SET @create_string = @create_string+ ' FILEGROWTH = 5 )'

PRINT ' '
PRINT 'use master'
EXEC ('use master')
PRINT @create_string
EXEC (@create_string)
IF @@ERROR <> 0
BEGIN
SET @bError = 1
END

SET @alter_string = 'ALTER DATABASE JDE_'+@upathcode+' SET RECOVERY SIMPLE'
PRINT ' '
PRINT @alter_string
EXEC (@alter_string)
IF @@ERROR <> 0
BEGIN
SET @bError = 1
END

IF (@bError = 1)
BEGIN
PRINT ' '
RAISERROR ('Database Create Failed: %s',15,1,@upathcode)
END

GO


[/ QUOTE ]