Hi Family.

I'm having enough frustration getting cross-system restore to work. But this is SO frustrating:

With my entire environment set up by a script that has been working for years, I made the modification:

/usr/informix/bin/onbar_d -r -p -w -t "2023-11-30 05:00:00"

And it's immediate response is:

4024  4022 Invalid Point In Time value specified: .

...

4024  4022 /usr/informix/bin/onbar_d complete, returning 149 (0x95)

This is INSANE! (Anyone remember the Crazy Eddie ads? :-)  I am being stopped by an unreasonable bouncer right at the door!  And, BTW, the same response if I use single quotes.  Our time zone is US so there is no issue with the date format and I have manually used that date in the recent past.  Our NetBackup guy assures me the tapes for that time slot are still on line.  (Or is he wrong?)

Anyone seen this little horror before?  And what did you do about it?

Thanks much!

-- Jacob S

Hi Family.

I'm having enough frustration getting cross-system restore to work. But this is SO frustrating:

With my entire environment set up by a script that has been working for years, I made the modification:

/usr/informix/bin/onbar_d -r -p -w -t "2023-11-30 05:00:00"

And it's immediate response is:

4024  4022 Invalid Point In Time value specified: .

...

4024  4022 /usr/informix/bin/onbar_d complete, returning 149 (0x95)

This is INSANE! (Anyone remember the Crazy Eddie ads? :-)  I am being stopped by an unreasonable bouncer right at the door!  And, BTW, the same response if I use single quotes.  Our time zone is US so there is no issue with the date format and I have manually used that date in the recent past.  Our NetBackup guy assures me the tapes for that time slot are still on line.  (Or is he wrong?)

Anyone seen this little horror before?  And what did you do about it?

Thanks much!

-- Jacob S

Thanks, Paul.

No issue with GL-DATETIME.  I had run a similar PIT restore a few weeks ago and used the identical parameters and date/time format. Just to check I just manually did an onbar run with a deliberately bad date format.  It gave me the identical "invalid point in time value" error.  So the bouncer is just being too eager.

Ya just gotta love these clear error messages!

Hi Family.

I'm having enough frustration getting cross-system restore to work. But this is SO frustrating:

With my entire environment set up by a script that has been working for years, I made the modification:

/usr/informix/bin/onbar_d -r -p -w -t "2023-11-30 05:00:00"

And it's immediate response is:

4024  4022 Invalid Point In Time value specified: .

...

4024  4022 /usr/informix/bin/onbar_d complete, returning 149 (0x95)

This is INSANE! (Anyone remember the Crazy Eddie ads? :-)  I am being stopped by an unreasonable bouncer right at the door!  And, BTW, the same response if I use single quotes.  Our time zone is US so there is no issue with the date format and I have manually used that date in the recent past.  Our NetBackup guy assures me the tapes for that time slot are still on line.  (Or is he wrong?)

Anyone seen this little horror before?  And what did you do about it?

Thanks much!

-- Jacob S

Thanks, Paul.

No issue with GL-DATETIME.  I had run a similar PIT restore a few weeks ago and used the identical parameters and date/time format. Just to check I just manually did an onbar run with a deliberately bad date format.  It gave me the identical "invalid point in time value" error.  So the bouncer is just being too eager.

Ya just gotta love these clear error messages!

Hi Family.

I'm having enough frustration getting cross-system restore to work. But this is SO frustrating:

With my entire environment set up by a script that has been working for years, I made the modification:

/usr/informix/bin/onbar_d -r -p -w -t "2023-11-30 05:00:00"

And it's immediate response is:

4024  4022 Invalid Point In Time value specified: .

...

4024  4022 /usr/informix/bin/onbar_d complete, returning 149 (0x95)

This is INSANE! (Anyone remember the Crazy Eddie ads? :-)  I am being stopped by an unreasonable bouncer right at the door!  And, BTW, the same response if I use single quotes.  Our time zone is US so there is no issue with the date format and I have manually used that date in the recent past.  Our NetBackup guy assures me the tapes for that time slot are still on line.  (Or is he wrong?)

Anyone seen this little horror before?  And what did you do about it?

Thanks much!

-- Jacob S

Hi Family.

I'm having enough frustration getting cross-system restore to work. But this is SO frustrating:

With my entire environment set up by a script that has been working for years, I made the modification:

/usr/informix/bin/onbar_d -r -p -w -t "2023-11-30 05:00:00"

And it's immediate response is:

4024  4022 Invalid Point In Time value specified: .

...

4024  4022 /usr/informix/bin/onbar_d complete, returning 149 (0x95)

This is INSANE! (Anyone remember the Crazy Eddie ads? :-)  I am being stopped by an unreasonable bouncer right at the door!  And, BTW, the same response if I use single quotes.  Our time zone is US so there is no issue with the date format and I have manually used that date in the recent past.  Our NetBackup guy assures me the tapes for that time slot are still on line.  (Or is he wrong?)

Anyone seen this little horror before?  And what did you do about it?

Thanks much!

-- Jacob S

Have you tried it without the "-w"?

Hi Family.

I'm having enough frustration getting cross-system restore to work. But this is SO frustrating:

With my entire environment set up by a script that has been working for years, I made the modification:

/usr/informix/bin/onbar_d -r -p -w -t "2023-11-30 05:00:00"

And it's immediate response is:

4024  4022 Invalid Point In Time value specified: .

...

4024  4022 /usr/informix/bin/onbar_d complete, returning 149 (0x95)

This is INSANE! (Anyone remember the Crazy Eddie ads? :-)  I am being stopped by an unreasonable bouncer right at the door!  And, BTW, the same response if I use single quotes.  Our time zone is US so there is no issue with the date format and I have manually used that date in the recent past.  Our NetBackup guy assures me the tapes for that time slot are still on line.  (Or is he wrong?)

Anyone seen this little horror before?  And what did you do about it?

Thanks much!

-- Jacob S

Hi Family.

I'm having enough frustration getting cross-system restore to work. But this is SO frustrating:

With my entire environment set up by a script that has been working for years, I made the modification:

/usr/informix/bin/onbar_d -r -p -w -t "2023-11-30 05:00:00"

And it's immediate response is:

4024  4022 Invalid Point In Time value specified: .

...

4024  4022 /usr/informix/bin/onbar_d complete, returning 149 (0x95)

This is INSANE! (Anyone remember the Crazy Eddie ads? :-)  I am being stopped by an unreasonable bouncer right at the door!  And, BTW, the same response if I use single quotes.  Our time zone is US so there is no issue with the date format and I have manually used that date in the recent past.  Our NetBackup guy assures me the tapes for that time slot are still on line.  (Or is he wrong?)

Anyone seen this little horror before?  And what did you do about it?

Thanks much!

-- Jacob S

This error, in my view clearly, refers only to the PIT datetime string provided and to onbar's inability to properly parse it - given potential external factors like CLIENT_LOCALE, GL_DATETIME, DBTIME env vars.

Hi Family.

I'm having enough frustration getting cross-system restore to work. But this is SO frustrating:

With my entire environment set up by a script that has been working for years, I made the modification:

/usr/informix/bin/onbar_d -r -p -w -t "2023-11-30 05:00:00"

And it's immediate response is:

4024  4022 Invalid Point In Time value specified: .

...

4024  4022 /usr/informix/bin/onbar_d complete, returning 149 (0x95)

This is INSANE! (Anyone remember the Crazy Eddie ads? :-)  I am being stopped by an unreasonable bouncer right at the door!  And, BTW, the same response if I use single quotes.  Our time zone is US so there is no issue with the date format and I have manually used that date in the recent past.  Our NetBackup guy assures me the tapes for that time slot are still on line.  (Or is he wrong?)

Anyone seen this little horror before?  And what did you do about it?

Thanks much!

-- Jacob S

What is the contacts of the ixbar file?

This error, in my view clearly, refers only to the PIT datetime string provided and to onbar's inability to properly parse it - given potential external factors like CLIENT_LOCALE, GL_DATETIME, DBTIME env vars.

Hi Family.

I'm having enough frustration getting cross-system restore to work. But this is SO frustrating:

With my entire environment set up by a script that has been working for years, I made the modification:

/usr/informix/bin/onbar_d -r -p -w -t "2023-11-30 05:00:00"

And it's immediate response is:

4024  4022 Invalid Point In Time value specified: .

...

4024  4022 /usr/informix/bin/onbar_d complete, returning 149 (0x95)

This is INSANE! (Anyone remember the Crazy Eddie ads? :-)  I am being stopped by an unreasonable bouncer right at the door!  And, BTW, the same response if I use single quotes.  Our time zone is US so there is no issue with the date format and I have manually used that date in the recent past.  Our NetBackup guy assures me the tapes for that time slot are still on line.  (Or is he wrong?)

Anyone seen this little horror before?  And what did you do about it?

Thanks much!

-- Jacob S

Two things:

Why are you doing the onbar deamon?

What is the od dump of you date string?

What is the contacts of the ixbar file?

This error, in my view clearly, refers only to the PIT datetime string provided and to onbar's inability to properly parse it - given potential external factors like CLIENT_LOCALE, GL_DATETIME, DBTIME env vars.

Hi Family.

I'm having enough frustration getting cross-system restore to work. But this is SO frustrating:

With my entire environment set up by a script that has been working for years, I made the modification:

/usr/informix/bin/onbar_d -r -p -w -t "2023-11-30 05:00:00"

And it's immediate response is:

4024  4022 Invalid Point In Time value specified: .

...

4024  4022 /usr/informix/bin/onbar_d complete, returning 149 (0x95)

This is INSANE! (Anyone remember the Crazy Eddie ads? :-)  I am being stopped by an unreasonable bouncer right at the door!  And, BTW, the same response if I use single quotes.  Our time zone is US so there is no issue with the date format and I have manually used that date in the recent past.  Our NetBackup guy assures me the tapes for that time slot are still on line.  (Or is he wrong?)

Anyone seen this little horror before?  And what did you do about it?

Thanks much!

-- Jacob S

Good point there, Wayne.

I copy/pasted the command-line in the bar_act.log into my post; Of course I did not run onbar_d directly.  Let that "_d" be stricken from the record. :-)

In any case, I have already posted that it turns out that date was rejected because the backup set for that date had expired and is no longer on the storage manager.  On the other hand, Nov 4 of that year is still on line (different expiration schedule) so I am working on that angle.  Other errors but the date passed muster.

BTW, when I deliberately used a syntactically incorrect date like '1234345 89765" it gave the identical error message. Hence the confusion.  It might be nice if it would tell me "That date was expired" or "Data for that date not on storage manager."  Y'know, something that would actually tell me what's wrong.  This is something I always complained about while at Informix and IBM has always been notorious for unhelpful diagnostics.

Two things:

Why are you doing the onbar deamon?

What is the od dump of you date string?

What is the contacts of the ixbar file?

This error, in my view clearly, refers only to the PIT datetime string provided and to onbar's inability to properly parse it - given potential external factors like CLIENT_LOCALE, GL_DATETIME, DBTIME env vars.

Hi Family.

I'm having enough frustration getting cross-system restore to work. But this is SO frustrating:

With my entire environment set up by a script that has been working for years, I made the modification:

/usr/informix/bin/onbar_d -r -p -w -t "2023-11-30 05:00:00"

And it's immediate response is:

4024  4022 Invalid Point In Time value specified: .

...

4024  4022 /usr/informix/bin/onbar_d complete, returning 149 (0x95)

This is INSANE! (Anyone remember the Crazy Eddie ads? :-)  I am being stopped by an unreasonable bouncer right at the door!  And, BTW, the same response if I use single quotes.  Our time zone is US so there is no issue with the date format and I have manually used that date in the recent past.  Our NetBackup guy assures me the tapes for that time slot are still on line.  (Or is he wrong?)

Anyone seen this little horror before?  And what did you do about it?

Thanks much!

-- Jacob S

Hi Family.

I'm having enough frustration getting cross-system restore to work. But this is SO frustrating:

With my entire environment set up by a script that has been working for years, I made the modification:

/usr/informix/bin/onbar_d -r -p -w -t "2023-11-30 05:00:00"

And it's immediate response is:

4024  4022 Invalid Point In Time value specified: .

...

4024  4022 /usr/informix/bin/onbar_d complete, returning 149 (0x95)

This is INSANE! (Anyone remember the Crazy Eddie ads? :-)  I am being stopped by an unreasonable bouncer right at the door!  And, BTW, the same response if I use single quotes.  Our time zone is US so there is no issue with the date format and I have manually used that date in the recent past.  Our NetBackup guy assures me the tapes for that time slot are still on line.  (Or is he wrong?)

Anyone seen this little horror before?  And what did you do about it?

Thanks much!

-- Jacob S