Conference orarep::nomahs::dbintegrator_public_public

1041.0. "%RMS-E-CRE, ACP file create fail" by GIDDAY::VASSIL () Wed Apr 03 1996 03:44

    Hi,
    
    I have a customer who keeps getting the following error message when
    attempting at doing a DEC ODBC driver connect on NT PC.
    
            %RMS-E-CRE, ACP file create fail
    
    The PC gets a %SQLSRV-F-FTLEXEERR, Fatal execute server error
    %RMS-E-CRE, ACP file create failed and ODBC does not add a data source.
    
    The customer also had an IVP error with an access violation (he did not
    trap the error message) while installing SQL/Services from the 
    [DECRDBA061] kit but says the product appeared to complete installing ok.
    
    I have very few skills in this area. Can anyone help in any way.
    
    The customer mailed me the following details of the DEC DB Integrator
    and SQL/Services setup.
    
    I am installing on an alpha running OpenVMS v6.0
    we do NOT have CDD, only the RMS file system at present
    We are using UCX v3.3. NO pathworks.
    
    NSDS was installed from the AXP December 1995 SPL CD Rom from the
    [NSDS_A_MD030] kit.
    
    SQL/Services was installed from the same CD rom from the [DECRDBA061]
    kit and whilst installing the IVP crashed with an access violation error. 
    The product appeared to complete installing ok.
    
     From user accounts, $SQL$ functions with our present exploratory
    investigations using the exmple database (*.DAT files & modified for
    NON CDD use of the NSDS$create_DATABASE.CDO file ).
    
    
    $ sho log *sql*,*nsds*
    
    (LNM$PROCESS_TABLE)
    
      "SQL$INSTALLED_VERSIONS" = "*V6.0-1"
      "SQLSRV$CONFIG_FILE" = "SYS$STARTUP:SQLSRV$CONFIG61.DAT"
      "SQLSRV$MAXSERVERS" = "20"
    
    (LNM$SYSTEM_TABLE)
    
      "NSDS$DATABASE" = "
    /type=NSDS/path=sys$common:[syshlp.examples.nsds]nsds$database.cdo "
      "NSDS$DEFAULT_DATA_DRIVER" = "NSDS$DDI_RMS_SHR"
      "NSDS$DEFAULT_DICTIONARY_DRIVER" =
    "SYS$SHARE:NSDS$MDI_CDO_READER_SHR.EXE"
      "SQL$DISABLE_CONTEXT" = "TRUE"
      "SQLSRV$ENABLE_SPX_CONNECTIONS" = "0"
      "SQLSRV$MAX_TCP_CONNECTIONS" = "5"
      "SQLSRV$NETCMD_MBX" = "MBA48:"
      "SQLSRV$ODBC" = "SYS$COMMON:[SQLSRV.ODBCAPI]"
    
    $ sql show version
    Current version of SQL is: DEC SQL V6.0-1
    
    $ Show system
    
    OpenVMS V6.2  on node LDEVL1   2-APR-1996 15:50:56.96  Uptime  0
    07:55:43
      Pid    Process Name    State  Pri      I/O       CPU       Page flts
    Pages
    00000041 SWAPPER         HIB     16        0   0 00:00:04.04         0
    0
    ...
    
    $ type sys$manager:sqlsrv$.log
    $       set noverify
    0402 0826520449530  Server Mailbox activated
    0402 0826520508120  DECnet Server activated
    0402 0826520508120  TCP/IP Server Socket Channel Assigned
    0402 0826520517885  TCP/IP Server activated
    0402 0827134403415  Process termination for PID 00000065
    0402 0827134403415    %RMS-E-CRE, ACP file create failed
    0402 0827134413180    BIO 7 DIO 7 Flts 39
    0402 0827134413180    Connect    0 00:00:00.12 CPU    0 00:00:00.05
    0402 0827134422945    Log File
    SYS$SYSDEVICE:[SQLSRV$SERVER]LDEVL1_SS_GENERIC_0000.LOG
    0402 1420263767670  Process termination for PID 0000006B
    0402 1420263777435    %RMS-E-CRE, ACP file create failed
    0402 1420263777435    BIO 7 DIO 7 Flts 39
    0402 1420263787200    Connect    0 00:00:00.13 CPU    0 00:00:00.05
    0402 1420263787200    Log File
    SYS$SYSDEVICE:[SQLSRV$SERVER61]LDEVL1_SS_V61_0001.LOG
    0402 1421359486035  Process termination for PID 0000006C
    0402 1421359495800    %RMS-E-CRE, ACP file create failed
    0402 1421359495800    BIO 7 DIO 5 Flts 39
    0402 1421359612980    Connect    0 00:00:00.07 CPU    0 00:00:00.04
    0402 1421359622745    Log File
    SYS$SYSDEVICE:[SQLSRV$SERVER]LDEVL1_SS_GENERIC_0002.LOG
    0402 1425191892770  Process termination for PID 0000006D
    0402 1425191902535    %RMS-E-CRE, ACP file create failed
    0402 1425191902535    BIO 7 DIO 5 Flts 39
    0402 1425191912300    Connect    0 00:00:00.09 CPU    0 00:00:00.03
    0402 1425191912300    Log File
    SYS$SYSDEVICE:[SQLSRV$SERVER]LDEVL1_SS_GENERIC_0003.LOG
    
    I do not find the
    SYS$SYSDEVICE:[SQLSRV$SERVER]LDEVL1_SS_GENERIC_nnnn.LOG
    files,
    
    
    DEC ODBC 32 Bit for NT:
    Class=generic
    userid=my VMS userid & password
    { if not a valid VMS account I get
           %SQLSRV-F-GETACCINF,SQL Services Authorization failed  }
    AttachStatement=attach 'filename NSDS$DATABASE'
    Transport=TCP/IP
    
        					Thanks,
    							Mario Vassil
    							Digital CSC
    							Sydney

    
    Hi,
    
    I think the acp file create failure may actually be for the creation of
    the log file.  You may want to open the directory up to w:wre access
    and see if that helps, or at least see if the protection on that
    directory (SYS$SYSDEVICE:[SQLSRV$SERVER61]) is open so that the sql
    services process has the ability to write to it.
    
    Please let us know if this doesn't help, I'm sure we can come up with
    lots of things to try!
    
    Regards,
    
    Dan

    
    Mario followed up and let us know that the problem was with the sql
    services account and the disk quota set for that account.
    
    dan