"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
>

"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
> >