Re: ARAdmin.exe Synch Search Database

2007-06-13 Thread Heider, Stephen
I even tried deleting the forms, then letting ARS recreate them by
running the Synch within the Administrator Tool.  

When running from the command line, I first TRUNCATE TABLE for the
tables behind the object_search_* SQL Views.

I wonder if another form has invalid fields and the Synch process
doesn't know how to handle them and is coughing up an error???

Stephen

 

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: Wednesday, June 13, 2007 9:29 AM
To: arslist@ARSLIST.ORG
Subject: Re: ARAdmin.exe Synch Search Database

It sounds like your object_search_ref or object_search_details form may
be messed up

Fred

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: Wednesday, June 13, 2007 6:46 AM
To: arslist@ARSLIST.ORG
Subject: ARAdmin.exe Synch Search Database

When running Tools > Synch Search Database within the Administrator Tool
it runs and there are no errors displayed.  When I run Synch Search
Database from the command line using "ARAdmin.exe -x Remedy -u Demo -p
secret -s" it runs and then at the very end displays the following text:

--
Starting Sync.
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line Sync Done.
--

These errors are probably generated within the Administrator Tool but
are just not displayed.  

What would cause these errors?  

ARS 6.3 (p16 & p21)
 
Stephen


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
the Answers Are"

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"


Re: ARAdmin.exe Synch Search Database

2007-06-13 Thread Grooms, Frederick W
It sounds like your object_search_ref or object_search_details form may
be messed up

Fred

-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen
Sent: Wednesday, June 13, 2007 6:46 AM
To: arslist@ARSLIST.ORG
Subject: ARAdmin.exe Synch Search Database

When running Tools > Synch Search Database within the Administrator Tool
it runs and there are no errors displayed.  When I run Synch Search
Database from the command line using "ARAdmin.exe -x Remedy -u Demo -p
secret -s" it runs and then at the very end displays the following text:

--
Starting Sync.
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line Sync Done.
--

These errors are probably generated within the Administrator Tool but
are just not displayed.  

What would cause these errors?  

ARS 6.3 (p16 & p21)
 
Stephen

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"


ARAdmin.exe Synch Search Database

2007-06-13 Thread Heider, Stephen
When running Tools > Synch Search Database within the Administrator Tool
it runs and there are no errors displayed.  When I run Synch Search
Database from the command line using "ARAdmin.exe -x Remedy -u Demo -p
secret -s" it runs and then at the very end displays the following text:

--
Starting Sync.
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
  *** Error 2131
 Incompatible data types in qualification line
Sync Done.
--

These errors are probably generated within the Administrator Tool but
are just not displayed.  

What would cause these errors?  

ARS 6.3 (p16 & p21)
 
Stephen

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the 
Answers Are"