SQLH2
in [Server Configuration]
|
From: Grigory Pogulsky (MS) on 15 Mar 2007 19:03 This sometimes happens when you have Sybase bcp in the path. Run bcp /v from SQLH2 folder to find out. If that's the case you need to make sure MS bcp is first in the path, so it gets called. "EmeraldDBA" wrote: > I installed SQLH2 - followed directions closely :). All seem to work as > described, except for the performance data. I am consistently receiving. > > 1/31/2007 10:32:55 AM INFO: > C:\SQLH2\PerfCollector\Data\pfc013107072759.txt: fid = 16, state = 0, retry > = 0 > 1/31/2007 10:32:55 AM Status: Perf records loaded: 0 > > I read the FAQs posted on the support site and tried running the app with > “/d”, checked the localization info, etc. unfortunately no luck. > > Someone on my team looked around the repository tables and found that after > the insert into p_files the app tries to update newly inserted row with guid > information by joining to pt_guid1, table which has no data. I tried > rebuilding the repository, and again no luck. > > Any help would be greatly appreciated. > > Thanks, > Paul >
From: EmeraldDBA on 15 Mar 2007 19:19 Right on. I - reordered the path - all works. "Grigory Pogulsky (MS)" wrote: > This sometimes happens when you have Sybase bcp in the path. > Run bcp /v from SQLH2 folder to find out. > If that's the case you need to make sure MS bcp is first in the path, so it > gets called. > > "EmeraldDBA" wrote: > > > I installed SQLH2 - followed directions closely :). All seem to work as > > described, except for the performance data. I am consistently receiving. > > > > 1/31/2007 10:32:55 AM INFO: > > C:\SQLH2\PerfCollector\Data\pfc013107072759.txt: fid = 16, state = 0, retry > > = 0 > > 1/31/2007 10:32:55 AM Status: Perf records loaded: 0 > > > > I read the FAQs posted on the support site and tried running the app with > > “/d”, checked the localization info, etc. unfortunately no luck. > > > > Someone on my team looked around the repository tables and found that after > > the insert into p_files the app tries to update newly inserted row with guid > > information by joining to pt_guid1, table which has no data. I tried > > rebuilding the repository, and again no luck. > > > > Any help would be greatly appreciated. > > > > Thanks, > > Paul > >
|
Pages: 1 Prev: Cannot bulk load. Invalid column number in the format file Next: connection issue |