**

Hi @ll,

All the tables has suddenly this problem.



If I open the form in REMEDY USER and look for records, then the following error appears:

“ARERR [552] Failure during SQL operation to the database. The object name ‘T35’ is not valid. (SQL Server 208)”



I can open the form in REMEDY ADMINISTRATOR, but if I make a change and save, then the following error appears:

“Operation completed successfully but the SQL view is not in place [ARERR 69]”



I’m working with Remedy 5.0 and SQL SERVER 2000 database.



I have seen similar issues in the arslist database, but the answers has been useless.



Can anybody help me?



Thanks and best regards,

David.

This posting was submitted via the Web interface

David,

Did you, by any chance, change the AR Database user name?

Is it possible that the table and/or view owner in SQL Server
Administrator is other than 'dbo' or the current AR Database user? If
so, you should use spchangeobjectowner to make 'dbo' the owner again.

Good luck!


----- Original Message -----
From: David Arroyo
Date: Wed, 22 Sep 2004 12:49:20 +0200
Subject: ARERR [552]: The object name 'T35' is not valid
To: arslist@arslist.org

**


Hi @ll,

All the tables has suddenly this problem.



If I open the form in REMEDY USER and look for records, then the
following error appears:

"ARERR [552] Failure during SQL operation to the database. The object
name 'T35' is not valid. (SQL Server 208)"



I can open the form in REMEDY ADMINISTRATOR, but if I make a change
and save, then the following error appears:

"Operation completed successfully but the SQL view is not in place [ARERR 69]"



I'm working with Remedy 5.0 and SQL SERVER 2000 database.



I have seen similar issues in the arslist database, but the answers
has been useless.



Can anybody help me?



Thanks and best regards,

David.
UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX
SUPPORT SERVICES at www.QMXS.com This posting was submitted via the
Web interface

Hello, thanks for your response.

In the SQL Server I see that all the form tables (Ts, Hs,...) had
"ARNTUser" as owner, but all the system tables (actlink, actlinkauto,
actlinkcall, etc...) has "dbo" as owner.

Do you think this can be the origin of the problem? I don't know how to
change the owner and I don't know what's "spchangeobjectwoner".

The database is in a Windows 2000 server pc.

-----Mensaje original-----
De: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG] En nombre de Mr Mojo Risin
Enviado el: miercoles, 22 de septiembre de 2004 13:00
Para: ARSLIST@ARSLIST.ORG
Asunto: Re: ARERR [552]: The object name 'T35' is not valid

David,

Did you, by any chance, change the AR Database user name?

Is it possible that the table and/or view owner in SQL Server
Administrator is other than 'dbo' or the current AR Database user? If
so, you should use spchangeobjectowner to make 'dbo' the owner again.

Good luck!


----- Original Message -----
From: David Arroyo
Date: Wed, 22 Sep 2004 12:49:20 +0200
Subject: ARERR [552]: The object name 'T35' is not valid
To: arslist@arslist.org

**


Hi @ll,

All the tables has suddenly this problem.



If I open the form in REMEDY USER and look for records, then the
following error appears:

"ARERR [552] Failure during SQL operation to the database. The object
name 'T35' is not valid. (SQL Server 208)"



I can open the form in REMEDY ADMINISTRATOR, but if I make a change
and save, then the following error appears:

"Operation completed successfully but the SQL view is not in place
[ARERR 69]"



I'm working with Remedy 5.0 and SQL SERVER 2000 database.



I have seen similar issues in the arslist database, but the answers
has been useless.



Can anybody help me?



Thanks and best regards,

David.


UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX
SUPPORT SERVICES at www.QMXS.com This posting was submitted via the
Web interface



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com

No, this sounds ok.
But: what owner has the T35 table? And what owner has the corresponding view?

On Wed, 22 Sep 2004 13:44:39 +0200, David Arroyo
wrote:
> Hello, thanks for your response.
>
> In the SQL Server I see that all the form tables (Ts, Hs,...) had
> "ARNTUser" as owner, but all the system tables (actlink, actlinkauto,
> actlinkcall, etc...) has "dbo" as owner.
>
> Do you think this can be the origin of the problem? I don't know how to
> change the owner and I don't know what's "spchangeobjectwoner".
>
> The database is in a Windows 2000 server pc.
>
> -----Mensaje original-----
> De: Action Request System discussion list(ARSList)
> [mailto:ARSLIST@ARSLIST.ORG] En nombre de Mr Mojo Risin
> Enviado el: miercoles, 22 de septiembre de 2004 13:00
> Para: ARSLIST@ARSLIST.ORG
> Asunto: Re: ARERR [552]: The object name 'T35' is not valid
>
>
>
> David,
>
> Did you, by any chance, change the AR Database user name?
>
> Is it possible that the table and/or view owner in SQL Server
> Administrator is other than 'dbo' or the current AR Database user? If
> so, you should use spchangeobjectowner to make 'dbo' the owner again.
>
> Good luck!
>
> ----- Original Message -----
> From: David Arroyo
> Date: Wed, 22 Sep 2004 12:49:20 +0200
> Subject: ARERR [552]: The object name 'T35' is not valid
> To: arslist@arslist.org
>
> **
>
> Hi @ll,
>
> All the tables has suddenly this problem.
>
> If I open the form in REMEDY USER and look for records, then the
> following error appears:
>
> "ARERR [552] Failure during SQL operation to the database. The object
> name 'T35' is not valid. (SQL Server 208)"
>
> I can open the form in REMEDY ADMINISTRATOR, but if I make a change
> and save, then the following error appears:
>
> "Operation completed successfully but the SQL view is not in place
> [ARERR 69]"
>
> I'm working with Remedy 5.0 and SQL SERVER 2000 database.
>
> I have seen similar issues in the arslist database, but the answers
> has been useless.
>
> Can anybody help me?
>
> Thanks and best regards,
>
> David.
>
>
> UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org ) ARSList is hosted by QMX
> SUPPORT SERVICES at www.QMXS.com This posting was submitted via the
> Web interface
>
>
>
> UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
> SERVICES at www.QMXS.com
>
>
>
>
>
>

The T35 table and its correspondig view has the same owner: ARNTUser

-----Mensaje original-----
De: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG] En nombre de Mr Mojo Risin
Enviado el: miercoles, 22 de septiembre de 2004 14:01
Para: ARSLIST@ARSLIST.ORG
Asunto: Re: ARERR [552]: The object name 'T35' is not valid

No, this sounds ok.
But: what owner has the T35 table? And what owner has the corresponding
view?

On Wed, 22 Sep 2004 13:44:39 +0200, David Arroyo
wrote:
> Hello, thanks for your response.
>
> In the SQL Server I see that all the form tables (Ts, Hs,...) had
> "ARNTUser" as owner, but all the system tables (actlink, actlinkauto,
> actlinkcall, etc...) has "dbo" as owner.
>
> Do you think this can be the origin of the problem? I don't know how
to
> change the owner and I don't know what's "spchangeobjectwoner".
>
> The database is in a Windows 2000 server pc.
>
> -----Mensaje original-----
> De: Action Request System discussion list(ARSList)
> [mailto:ARSLIST@ARSLIST.ORG] En nombre de Mr Mojo Risin
> Enviado el: miercoles, 22 de septiembre de 2004 13:00
> Para: ARSLIST@ARSLIST.ORG
> Asunto: Re: ARERR [552]: The object name 'T35' is not valid
>
>
>
> David,
>
> Did you, by any chance, change the AR Database user name?
>
> Is it possible that the table and/or view owner in SQL Server
> Administrator is other than 'dbo' or the current AR Database user? If
> so, you should use spchangeobjectowner to make 'dbo' the owner again.
>
> Good luck!
>
> ----- Original Message -----
> From: David Arroyo
> Date: Wed, 22 Sep 2004 12:49:20 +0200
> Subject: ARERR [552]: The object name 'T35' is not valid
> To: arslist@arslist.org
>
> **
>
> Hi @ll,
>
> All the tables has suddenly this problem.
>
> If I open the form in REMEDY USER and look for records, then the
> following error appears:
>
> "ARERR [552] Failure during SQL operation to the database. The object
> name 'T35' is not valid. (SQL Server 208)"
>
> I can open the form in REMEDY ADMINISTRATOR, but if I make a change
> and save, then the following error appears:
>
> "Operation completed successfully but the SQL view is not in place
> [ARERR 69]"
>
> I'm working with Remedy 5.0 and SQL SERVER 2000 database.
>
> I have seen similar issues in the arslist database, but the answers
> has been useless.
>
> Can anybody help me?
>
> Thanks and best regards,
>
> David.
>

>
> UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org ) ARSList is hosted by QMX
> SUPPORT SERVICES at www.QMXS.com This posting was submitted via the
> Web interface
>
>

>
> UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org ) ARSList is hosted by QMX
SUPPORT
> SERVICES at www.QMXS.com
>
>
>
>


> UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com
>



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com

you can use spchangedbowner to change the owner of the db. If you
recently changed SQL server between native/mixed mode authentication, or if
you changed the OS user that Remedy runs as (which effects the connect info
for native mode), this can cause problems with remedy process/db
permissions.

Kind Regards,
Axton Grams
New York Life
Remedy Solutions
Provider

Mobile: 404.861.7273
Work: 770.406.4415
Email: AxtonWGrams@NewYorkLife.com






|---------+---------------------------->
| | David Arroyo |
| | | | ITY.COM> |
| | Sent by: "Action |
| | Request System |
| | discussion |
| | list(ARSList)" |
| | | | ORG> |
| | |
| | |
| | 09/22/2004 08:35 |
| | AM |
| | Please respond to|
| | arslist |
| | |
|---------+---------------------------->
>------------------------------------------------------------------------------------------------------------------------------|
| |
| To: ARSLIST@ARSLIST.ORG |
| cc: |
| Subject: Re: ARERR [552]: The object name 'T35' is not valid |
>------------------------------------------------------------------------------------------------------------------------------|




The T35 table and its correspondig view has the same owner: ARNTUser

-----Mensaje original-----
De: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG] En nombre de Mr Mojo Risin
Enviado el: miercoles, 22 de septiembre de 2004 14:01
Para: ARSLIST@ARSLIST.ORG
Asunto: Re: ARERR [552]: The object name 'T35' is not valid

No, this sounds ok.
But: what owner has the T35 table? And what owner has the corresponding
view?

On Wed, 22 Sep 2004 13:44:39 +0200, David Arroyo
wrote:
> Hello, thanks for your response.
>
> In the SQL Server I see that all the form tables (Ts, Hs,...) had
> "ARNTUser" as owner, but all the system tables (actlink, actlinkauto,
> actlinkcall, etc...) has "dbo" as owner.
>
> Do you think this can be the origin of the problem? I don't know how
to
> change the owner and I don't know what's "spchangeobjectwoner".
>
> The database is in a Windows 2000 server pc.
>
> -----Mensaje original-----
> De: Action Request System discussion list(ARSList)
> [mailto:ARSLIST@ARSLIST.ORG] En nombre de Mr Mojo Risin
> Enviado el: miercoles, 22 de septiembre de 2004 13:00
> Para: ARSLIST@ARSLIST.ORG
> Asunto: Re: ARERR [552]: The object name 'T35' is not valid
>
>
>
> David,
>
> Did you, by any chance, change the AR Database user name?
>
> Is it possible that the table and/or view owner in SQL Server
> Administrator is other than 'dbo' or the current AR Database user? If
> so, you should use spchangeobjectowner to make 'dbo' the owner again.
>
> Good luck!
>
> ----- Original Message -----
> From: David Arroyo
> Date: Wed, 22 Sep 2004 12:49:20 +0200
> Subject: ARERR [552]: The object name 'T35' is not valid
> To: arslist@arslist.org
>
> **
>
> Hi @ll,
>
> All the tables has suddenly this problem.
>
> If I open the form in REMEDY USER and look for records, then the
> following error appears:
>
> "ARERR [552] Failure during SQL operation to the database. The object
> name 'T35' is not valid. (SQL Server 208)"
>
> I can open the form in REMEDY ADMINISTRATOR, but if I make a change
> and save, then the following error appears:
>
> "Operation completed successfully but the SQL view is not in place
> [ARERR 69]"
>
> I'm working with Remedy 5.0 and SQL SERVER 2000 database.
>
> I have seen similar issues in the arslist database, but the answers
> has been useless.
>
> Can anybody help me?
>
> Thanks and best regards,
>
> David.
>

>
> UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org ) ARSList is hosted by QMX
> SUPPORT SERVICES at www.QMXS.com This posting was submitted via the
> Web interface
>
>

>
> UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
> (Support: mailto:support@arslist.org ) ARSList is hosted by QMX
SUPPORT
> SERVICES at www.QMXS.com
>
>
>
>


> UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com
>



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com


UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org (Support:
mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT SERVICES at
www.QMXS.com

Hello David,

I don't think that this is a permission problem.

It sounds to me that you have a problem with the ars dictionary.
Mostly this appears if a form manipulation wasn't saved properly.
Did the Admin Tool crashed during saving a form?
Do you used ARMigrator and Migrator crashed?

> If I open the form in REMEDY USER and look for records, then the following error appears:
> “ARERR [552] Failure during SQL operation to the database. The object name ‘T35’ is not valid.
> (SQL Server 208)”
> I can open the form in REMEDY ADMINISTRATOR, but if I make a change and save, then the
> following error appears:
> “Operation completed successfully but the SQL view is not in place [ARERR 69]”
> I’m working with Remedy 5.0 and SQL SERVER 2000 database.
> I have seen similar issues in the arslist database, but the answers has been useless.

The message "SQL view not in place" often means that there is a
disparity
in table columns (attributes) and the information in the ars dictionary.

Please check the description of the sql view. Do you have the correct
number
of columns if you compare the view with T35?

Please check the content of Table FIELD with "select * from field where
schemaid = 35".
Maybe you'll find a field that don't appear in T35 itself?

After this please check this: "select name, schemaid, numfields where
schemaid = 35"
What does the numfields tell you?

HTH
Regards Ruediger

Hello,
The admin. Tool has not crashed during saving a form and I don't use
ARMigrator but... what would be the solution if I have a problem with
the ars dictionary?

-----Mensaje original-----
De: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG] En nombre de Ruediger Tams
Enviado el: miercoles, 22 de septiembre de 2004 18:32
Para: ARSLIST@ARSLIST.ORG
Asunto: Re: ARERR [552]: The object name 'T35' is not valid

Hello David,

I don't think that this is a permission problem.

It sounds to me that you have a problem with the ars dictionary.
Mostly this appears if a form manipulation wasn't saved properly.
Did the Admin Tool crashed during saving a form?
Do you used ARMigrator and Migrator crashed?

> If I open the form in REMEDY USER and look for records, then the
following error appears:
> “ARERR [552] Failure during SQL operation to the database. The object
name ‘T35’ is not valid.
> (SQL Server 208)”
> I can open the form in REMEDY ADMINISTRATOR, but if I make a change
and save, then the
> following error appears:
> “Operation completed successfully but the SQL view is not in place
[ARERR 69]”
> I’m working with Remedy 5.0 and SQL SERVER 2000 database.
> I have seen similar issues in the arslist database, but the answers
has been useless.

The message "SQL view not in place" often means that there is a
disparity
in table columns (attributes) and the information in the ars dictionary.

Please check the description of the sql view. Do you have the correct
number
of columns if you compare the view with T35?

Please check the content of Table FIELD with "select * from field where
schemaid = 35".
Maybe you'll find a field that don't appear in T35 itself?

After this please check this: "select name, schemaid, numfields where
schemaid = 35"
What does the numfields tell you?

HTH
Regards Ruediger



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com

> ------------------------------------------------------------------------
>
> Hello David,
>
> do you still have the problems with T35 or did you solved it?
>
> Sometimes, if the disparity isn't too big, it's possible to
> check the data in the ars dictionary tables and correct it.
> Sometimes it's possible to use ARAdmin to save the form anew
> and correct the problem this way.
>
> First, please run the statements below and tell me the results:
>
> * select name, schemaid, numfields from arschema where schemaid = 35
> * select count(*) from field where schemaid = 35
> * select * from field where schemaid = 35
>
> Second, please have a look at the description of your error messages:
>
> 552 Failure during SQL operation to the database.
> This generic message indicates that an SQL database error was returned
> during an
> operation against the database. An associated error message is the full
> text of the error
> message from the database that describes the failure encountered.
> The error is often a message about running out of space in the database
> log or data
> area. You can correct this by increasing the size of the data area or by
> flushing or
> increasing the size of the log area.
>
> 69 Creation of one of the SQL views for the form failed within the SQL
> database.
> Operation was completed successfully, but the SQL view is not in place.
> While attempting to create the SQL view for this form, the system
> encountered the
> associated SQL error. This error prevented the creation of the SQL view.
> The table definition and the structure needed by AR System server is
> complete and in place.
> Only the SQL view for this form is not in place.
> The definition of the form and associated fields are complete and in
> place. You can
> access the form and continue with operation of the system. The only
> missing
> information is an SQL view for this form, which is needed only if you
> are directly
> accessing the SQL database by using the SQL view.
>
> Possibly you don't have enough database space for the log area of
> database
> ARSYSTEM (ARERR552)?
>
> HTH
> Ruediger
>
> David Arroyo schrieb:
> >
> > Hello,
> > The admin. Tool has not crashed during saving a form and I don't use
> > ARMigrator but... what would be the solution if I have a problem with
> > the ars dictionary?
> >
> > -----Mensaje original-----
> > De: Action Request System discussion list(ARSList)
> > [mailto:ARSLIST@ARSLIST.ORG] En nombre de Ruediger Tams
> > Enviado el: miercoles, 22 de septiembre de 2004 18:32
> > Para: ARSLIST@ARSLIST.ORG
> > Asunto: Re: ARERR [552]: The object name 'T35' is not valid
> >
> > Hello David,
> >
> > I don't think that this is a permission problem.
> >
> > It sounds to me that you have a problem with the ars dictionary.
> > Mostly this appears if a form manipulation wasn't saved properly.
> > Did the Admin Tool crashed during saving a form?
> > Do you used ARMigrator and Migrator crashed?
> >
> > > If I open the form in REMEDY USER and look for records, then the
> > following error appears:
> > > “ARERR [552] Failure during SQL operation to the database. The object
> > name ‘T35’ is not valid.
> > > (SQL Server 208)”
> > > I can open the form in REMEDY ADMINISTRATOR, but if I make a change
> > and save, then the
> > > following error appears:
> > > “Operation completed successfully but the SQL view is not in place
> > [ARERR 69]”
> > > I’m working with Remedy 5.0 and SQL SERVER 2000 database.
> > > I have seen similar issues in the arslist database, but the answers
> > has been useless.
> >
> > The message "SQL view not in place" often means that there is a
> > disparity
> > in table columns (attributes) and the information in the ars dictionary.
> >
> > Please check the description of the sql view. Do you have the correct
> > number
> > of columns if you compare the view with T35?
> >
> > Please check the content of Table FIELD with "select * from field where
> > schemaid = 35".
> > Maybe you'll find a field that don't appear in T35 itself?
> >
> > After this please check this: "select name, schemaid, numfields where
> > schemaid = 35"
> > What does the numfields tell you?
> >
> > HTH
> > Regards Ruediger
> >
>
>
>

Hello,
I continued with the problem.

It affected to all the table I had created, and all that tables had the
user "ARNTUser" as owner.

Now I have uninstalled remedy an reinstalled, and it's all OK. All the
tables has the user "dbo" as owner and I can view its data.

I wonder why suddenly this problem appeared, and hope it doesn't occurs
again.

Thanks and regards,
David.

-----Mensaje original-----
De: Action Request System discussion list(ARSList)
[mailto:ARSLIST@ARSLIST.ORG] En nombre de Ruediger Tams
Enviado el: lunes, 27 de septiembre de 2004 16:29
Para: ARSLIST@ARSLIST.ORG
Asunto: Re: ARERR [552]: The object name 'T35' is not valid

>
------------------------------------------------------------------------
>
> Hello David,
>
> do you still have the problems with T35 or did you solved it?
>
> Sometimes, if the disparity isn't too big, it's possible to
> check the data in the ars dictionary tables and correct it.
> Sometimes it's possible to use ARAdmin to save the form anew
> and correct the problem this way.
>
> First, please run the statements below and tell me the results:
>
> * select name, schemaid, numfields from arschema where schemaid = 35
> * select count(*) from field where schemaid = 35
> * select * from field where schemaid = 35
>
> Second, please have a look at the description of your error messages:
>
> 552 Failure during SQL operation to the database.
> This generic message indicates that an SQL database error was returned
> during an
> operation against the database. An associated error message is the
full
> text of the error
> message from the database that describes the failure encountered.
> The error is often a message about running out of space in the
database
> log or data
> area. You can correct this by increasing the size of the data area or
by
> flushing or
> increasing the size of the log area.
>
> 69 Creation of one of the SQL views for the form failed within the SQL
> database.
> Operation was completed successfully, but the SQL view is not in
place.
> While attempting to create the SQL view for this form, the system
> encountered the
> associated SQL error. This error prevented the creation of the SQL
view.
> The table definition and the structure needed by AR System server is
> complete and in place.
> Only the SQL view for this form is not in place.
> The definition of the form and associated fields are complete and in
> place. You can
> access the form and continue with operation of the system. The only
> missing
> information is an SQL view for this form, which is needed only if you
> are directly
> accessing the SQL database by using the SQL view.
>
> Possibly you don't have enough database space for the log area of
> database
> ARSYSTEM (ARERR552)?
>
> HTH
> Ruediger
>
> David Arroyo schrieb:
> >
> > Hello,
> > The admin. Tool has not crashed during saving a form and I don't use
> > ARMigrator but... what would be the solution if I have a problem
with
> > the ars dictionary?
> >
> > -----Mensaje original-----
> > De: Action Request System discussion list(ARSList)
> > [mailto:ARSLIST@ARSLIST.ORG] En nombre de Ruediger Tams
> > Enviado el: miercoles, 22 de septiembre de 2004 18:32
> > Para: ARSLIST@ARSLIST.ORG
> > Asunto: Re: ARERR [552]: The object name 'T35' is not valid
> >
> > Hello David,
> >
> > I don't think that this is a permission problem.
> >
> > It sounds to me that you have a problem with the ars dictionary.
> > Mostly this appears if a form manipulation wasn't saved properly.
> > Did the Admin Tool crashed during saving a form?
> > Do you used ARMigrator and Migrator crashed?
> >
> > > If I open the form in REMEDY USER and look for records, then the
> > following error appears:
> > > “ARERR [552] Failure during SQL operation to the database. The
object
> > name ‘T35’ is not valid.
> > > (SQL Server 208)”
> > > I can open the form in REMEDY ADMINISTRATOR, but if I make a
change
> > and save, then the
> > > following error appears:
> > > “Operation completed successfully but the SQL view is not in place
> > [ARERR 69]”
> > > I’m working with Remedy 5.0 and SQL SERVER 2000 database.
> > > I have seen similar issues in the arslist database, but the
answers
> > has been useless.
> >
> > The message "SQL view not in place" often means that there is a
> > disparity
> > in table columns (attributes) and the information in the ars
dictionary.
> >
> > Please check the description of the sql view. Do you have the
correct
> > number
> > of columns if you compare the view with T35?
> >
> > Please check the content of Table FIELD with "select * from field
where
> > schemaid = 35".
> > Maybe you'll find a field that don't appear in T35 itself?
> >
> > After this please check this: "select name, schemaid, numfields
where
> > schemaid = 35"
> > What does the numfields tell you?
> >
> > HTH
> > Regards Ruediger
> >
>
>


> UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com