Hi Sagar,

I am glad to see that this resolved your issue  :)

Unfortunately, I cannot tell you how the entry became corrupt to begin with. 
During the import of workflow that referenced a form that did not exist....an 
entry was created in arschema to allow for the import of associated workflow. 
Somehow the name got NULL'ed out   :(

Anyways, glad to hear you are again up and running.

Regards,
Ryan.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Sagar Valse
Sent: Friday, June 14, 2013 2:41 AM
To: arslist@ARSLIST.ORG
Subject: Re: Question related to placeholder forms

**
Hi Ryan,
Thanks a lot!!!
The issue got resolved.The blank placeholder was there in the database.
Just wondering how the blank placeholder got created.

On Thu, Jun 13, 2013 at 6:59 PM, Downing, Ryan 
<ryan_down...@bmc.com<mailto:ryan_down...@bmc.com>> wrote:
**
Hi Sagar,

You said you "tried" deleting the blank placeholder. Did it delete? Or did you 
get the error when you tried to delete?

Perform the following SQL query:

select name,schemaId from arschema

You should not have any entries in the arschema form with a NULL name value. If 
you do have any entries with a NULL value try the following:


1.       BACKUP your database

2.       Delete the entry or entries in arschema where the name is NULL

3.       Now try and create/modify/delete on any other form

Hopefully this will allow you to save/modify other forms.....

I hope this helps,

Regards,
Ryan.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Sagar 
Valse
Sent: Thursday, June 13, 2013 5:24 AM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Fwd: Question related to placeholder forms

**

 Hi Ryan\David,

I am facing similar issue and i tried deleting the blank placeholder as well.
But still i was getting same error.
Did you got any solution for issue.
Thanks and Regards,
Sagar Valse


**
Hi David,

Can you delete the "placeholder" form? It appears this particular placeholder 
form is corrupt. As you stated...even placeholder forms require a name.

Do you know what imported workflow would have created the placeholder form?

As an FYI:

Importing shared workflow not owned by the application
When you import an application definition file that contains shared workflow 
not owned by the application, AR System can create a non-functional placeholder 
form
for each external form associated with the shared workflow. This allows 
developers to modify the shared workflow owned by another application without 
installing the integrated application on the development server. It also 
ensures that the complete list of associated forms is preserved with any shared 
workflow.
Placeholder forms are created during application import in these cases:

*         The import definition contains shared workflow from another 
application that
includes a Push Fields or Set Fields action. In this case, a placeholder is 
created for the external form used by the Push Fields or Set Fields action.

*         The server configuration file (ar.cfg or ar.conf) contains the option 
Create-Workflow-Placeholders: T. In this case, a placeholder form is created 
for any external form associated with the shared workflow, regardless of the 
workflow action type.
A placeholder form has no fields and can only be deleted. If the actual 
definition of a placeholder form is imported, it replaces the existing 
placeholder. In the Forms object list in BMC Remedy Developer Studio, 
placeholder forms are identified as form type "None". When importing an 
application definition that contains shared workflow not owned by the 
application, the workflow object is created if it does not already exist. If 
the workflow object already exists, only the list of associated forms is 
updated. If the application that owns the shared workflow object is later 
imported, the workflow is replaced.

If the placeholder form can be deleted then I am hoping at that point you can 
create/save other forms.

Regards,
Ryan.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Longwing, 
Lj
Sent: Tuesday, April 16, 2013 2:00 PM

To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Re: Question related to placeholder forms

**
Ok, in that scenario, I can guarantee you that another form isn't at play.  To 
be able to help we will need the actual message that you are receiving, 
including error number, and if you could also turn on SQL Logging on the server 
before you do the save, and include the relevant portions of the log with the 
reply, that would also help.

On Tue, Apr 16, 2013 at 11:43 AM, Drake, David 
<david.dr...@kbslp.com<mailto:david.dr...@kbslp.com>> wrote:
**
Dev Studio

David Drake
Application Systems Analyst
ITSM Application Support
Koch Business Solutions, LP
email: david.dr...@kbslp.com<mailto:david.dr...@kbslp.com> | office: 
316-828-6113<tel:316-828-6113>| cell: 316-200-1991<tel:316-200-1991>
Error! Filename not specified.<http://myitsupport/>

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Longwing, 
Lj
Sent: Tuesday, April 16, 2013 12:20 PM
To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>
Subject: Re: Question related to placeholder forms

** By save, do you mean in dec studio or client?


On Tuesday, April 16, 2013, Drake, David 
<david.dr...@kbslp.com<mailto:david.dr...@kbslp.com>> wrote:
> **
>
> Need to see if anyone has any insight into the probable cause and/or fix for 
> the following
>
>
>
> We're no longer able to save any kind of forms. The error indicates that the 
> fields cannot be found. This is on a brand new regular form and the core 
> fields are right there so the error is coming from some other form that is 
> being accessed when saving this form. We have found a placeholder form but it 
> doesn't have a name (even though that's a required field) and we suspect that 
> may be the culprit. Has anyone any insight into this or something similar? 
> Thanks!
>
>
>
> ITSM 7.6.04 SP2, SQL2K5, Windows Server
>
>
>
> David Drake
>
> Application Systems Analyst
>
> ITSM Application Support
> Koch Business Solutions, LP
>
> email: david.dr...@kbslp.com<mailto:david.dr...@kbslp.com> | office: 
> 316-828-6113<tel:316-828-6113>| cell: 316-200-1991<tel:316-200-1991>
>
>
>
>
>
> _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: 
> "Where the Answers Are" and have been for 20 years_
_ARSlist: "Where the Answers Are" and have been for 20 years_

_ARSlist: "Where the Answers Are" and have been for 20 years_
_ARSlist: "Where the Answers Are" and have been for 20 years_




--
Thanks and Regards,
Sagar Valse


_ARSlist: "Where the Answers Are" and have been for 20 years_
_ARSlist: "Where the Answers Are" and have been for 20 years_

_ARSlist: "Where the Answers Are" and have been for 20 years_

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Reply via email to