Asset 'cat430050' is locked by Workspace 'name:ID' = 'epub-prj197006:31905' yet no Project was found owning that Workspace.

[Kadinamkulam]

Hi All,


Now I am getting this below error for some reason.
I removed the data from back end. but it did not removed completely.
How can I fix this issue ? kindly help,

Warm Regards
KdM

##################### ERROR

2012-09-26 13:25:51,256 WARN  [VersionManagerService] asset Beiber Fever already locked by workspace epub-prj197006.
2012-09-26 13:25:51,443 WARN  [ProjectServices] Asset 'cat430050' is locked by Workspace 'name:ID' = 'epub-prj197006:31905' yet no Project was found owning that Workspace.
2012-09-26 13:25:51,477 WARN  [ProjectServices] Asset 'cat310180' is locked by Workspace 'name:ID' = 'epub-prj197007:31906' yet no Project was found owning that Workspace.
2012-09-26 13:25:51,575 WARN  [WorkflowProcessManager] Error executing action approveAndDeployProject[target=Production] on process instance 38000004; reverting the process instance to its original state
CAUGHT AT:
CONTAINER:atg.process.ProcessException; SOURCE:atg.epub.project.AssetLockException: Failed to approve the project auto_category_prod_unlink_2012-09-26_01-16-56 (id: prj390003) for deployment. Unable to obtain exclusive locks to one or more assets. Use the Lock Conflicts page to determine which assets are locked by other projects.
    at atg.epub.workflow.process.action.ApproveProject.executeAction(ApproveProject.java:109)
    at atg.epub.workflow.process.action.ApproveAndDeployProject.executeAction(ApproveAndDeployProject.java:67)
    at atg.process.action.ActionImpl.execute(ActionImpl.java:397)


##################################################

On Thu, Aug 30, 2012 at 2:09 PM, Kadinamkulam <kadina...@gmail.com> wrote:

Thanks Gordon, Really Useful !!!!

I committed after executing the procedure.

Invalidated the repository cache..
/dyn/admin/nucleus/atg/epub/PublishingRepository/

All worked and the project got removed from BCC .. :)

Warm Regards
KdM

On Thu, Aug 30, 2012 at 1:49 PM, Gordon Cooke <gor...@sparkred.com> wrote:

Did you commit the transaction after running the proc?

This should remove all the relevant data from the system.

Gordon Cooke

Spark::red - Managed ATG Hosting

http://sparkred.com

gor...@sparkred.com

m: 206-384-1314

w: 888-666-5582

Follow Spark::red for the latest news on eCommerce and ATG:

Twitter - www.twitter.com/ATGhostingSpark

Facebook - www.facebook.com/SparkredATGHosting

Blog - www.sparkred.com/blog/

On Aug 30, 2012, at 11:07 AM, Kadinamkulam <kadina...@gmail.com> wrote:

Hi Gordon,

I executed this procedure and the data is removed from the db and restarted the CA instance.

But still I can see those projects in BCC.  is there any thing else we need to check.. like is there any lock or so ?


Warm Regards
KdM

On Thu, Aug 30, 2012 at 10:09 AM, Gordon Cooke <gor...@sparkred.com> wrote:

Not sure how others have done this but it is not as easy as that.  I use a stored procedure (for Oracle DB) that I set up in the PUB schema that looks something like the following.  I am sure there are more elegant ways of going about this but this works.

create or replace procedure clean_bcc_project( projid varchar2, procid varchar2)

is

begin

 for histid in(select history from epub_proc_history where process_id = procid) loop

   dbms_output.put_line(histid.history);

   delete from epub_proc_history where history = histid.history and process_id = procid;

   delete from epub_history where history_id = histid.history;

  end loop;

  

  for histidx in(select history from epub_pr_history where project_id = projid) loop

   dbms_output.put_line('History id is ' || histidx.history);

   delete from epub_pr_history where history = histidx.history and project_id = projid;

   delete from epub_history where history_id = histidx.history;

  end loop;

  

  for taskinfo in (select taskinfo_id from epub_proc_taskinfo where id = procid) loop

    dbms_output.put_line('Task info id is ' || taskinfo.taskinfo_id);

    delete from epub_proc_taskinfo where taskinfo_id = taskinfo.taskinfo_id and id = procid;

    delete from epub_taskinfo where taskinfo_id = taskinfo.taskinfo_id;

  end loop;

  delete from epub_project where project_id = projid;

  delete from epub_ind_workflow where process_id=procid;

  delete from epub_process where process_id = procid;

end;

--execute clean_bcc_project('prj381005','prc381005');

Gordon Cooke

Spark::red - Managed ATG Hosting

http://sparkred.com

gor...@sparkred.com

m: 206-384-1314

w: 888-666-5582

Follow Spark::red for the latest news on eCommerce and ATG:

Twitter - www.twitter.com/ATGhostingSpark

Facebook - www.facebook.com/SparkredATGHosting

Blog - www.sparkred.com/blog/

On Aug 30, 2012, at 6:58 AM, Kadinamkulam <kadina...@gmail.com> wrote:

HI  Experts,

What are the steps to remove a project from the BCC.

I tried to Delete it from bcc. but since the topology was not configured it got hanged in the deployment phase.
I tried the below remove-item  RQL but still I can see the project in bcc like orphan.

Is there any order in doing this ?

Please help,


Warm Regards
Kdm

SELECT COUNT(*), WORKSPACE_ID FROM CCAVERSION.AVM_ASSET_LOCK GROUP BY WORKSPACE_ID

 

Gives now of projects in editable

 

	COUNT(*)	WORKSPACE_ID
0	6	45785
1	4	47682
2	2	50564
3	7	52051

 

/atg/epub/PublishingRepository/

<print-item item-descriptor="project" id="prj19095"/>

<print-item item-descriptor="process" id="prc19095"/>

 

<delete-item item-descriptor="project" id="prj19095"/>

 

<remove-item item-descriptor="project" id="prj19095"/>

<remove-item item-descriptor="process" id="prc19095"/>

 

 

<print-item item-descriptor="process" id=" prc20002"/>

--
--
You received this message because you are subscribed to the Google Groups "ATG_Tech" group.
To post to this group, send email to atg_...@googlegroups.com
To unsubscribe from this group, send email to atg_tech-u...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/atg_tech?hl=en
 
 

--
--
You received this message because you are subscribed to the Google Groups "ATG_Tech" group.
To post to this group, send email to atg_...@googlegroups.com
To unsubscribe from this group, send email to atg_tech-u...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/atg_tech?hl=en
 
 

--
--
You received this message because you are subscribed to the Google Groups "ATG_Tech" group.
To post to this group, send email to atg_...@googlegroups.com
To unsubscribe from this group, send email to atg_tech-u...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/atg_tech?hl=en
 
 

--
--
You received this message because you are subscribed to the Google Groups "ATG_Tech" group.
To post to this group, send email to atg_...@googlegroups.com
To unsubscribe from this group, send email to atg_tech-u...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/atg_tech?hl=en
 
 

[amit ingle]

Did u delete it from  "avm_asset_lock" ?

Regards,

Amit

[Rajinder S. Nagi]

KDM,

     Do this step:

1) - Removing locks of the project if any
delete from avm_asset_lock where workspace_id in
(select id from avm_devline where name in
(select workspace from epub_project where project_id = '?'))

Invalidate below repository caches
/atg/epub/version/VersionManagerRepository/

Hope you already invalidated:

/atg/epub/PublishingRepository/

Best Regards,
Rajinder Singh
Oracle ATG Web Commerce Software Engineer
Contact: 404-932-2247
Twitter@Raj_Nagi, Profile: http://www.linkedin.com/in/raindernagi

[Kadinamkulam]

Thanks Rajinder and Amit,

I am able to get rid of this error, but the deployment is creating problem now withthe below error.
Is this related ?


Warm Regards
KdM


##############
2012-09-26 13:59:19,383 ERROR [DeploymentServer]
CAUGHT AT:
CONTAINER:atg.deployment.common.DeploymentException:     ; SOURCE:javax.ejb.ObjectNotFoundException
    at atg.deployment.common.ResourceUtil.exception(ResourceUtil.java:373)
    at atg.deployment.server.DeploymentServer.fetchProject(DeploymentServer.java:2176)
    at atg.deployment.server.DeploymentServer.fetchProjects(DeploymentServer.java:2203)
    at atg.deployment.server.Deployment.verifyParameters(Deployment.java:2259)
    at atg.deployment.server.Deployment.run(Deployment.java:1667)
    at java.lang.Thread.run(Thread.java:679)
Caused by: javax.ejb.ObjectNotFoundException
    at atg.repository.tojava.runtime.RJSupport.executeRqlStatementForOne(RJSupport.java:1103)
    at atg.epub.project._ProjectHome_ReposImpl.findById(_ProjectHome_ReposImpl.java:71)
    at atg.deployment.server.DeploymentServer.fetchProject(DeploymentServer.java:2169)
    ... 4 more
SOURCE EXCEPTION:
javax.ejb.ObjectNotFoundException
    at atg.repository.tojava.runtime.RJSupport.executeRqlStatementForOne(RJSupport.java:1103)
    at atg.epub.project._ProjectHome_ReposImpl.findById(_ProjectHome_ReposImpl.java:71)
    at atg.deployment.server.DeploymentServer.fetchProject(DeploymentServer.java:2169)
    at atg.deployment.server.DeploymentServer.fetchProjects(DeploymentServer.java:2203)
    at atg.deployment.server.Deployment.verifyParameters(Deployment.java:2259)
    at atg.deployment.server.Deployment.run(Deployment.java:1667)
    at java.lang.Thread.run(Thread.java:679)



#############

[Rajinder S. Nagi]

KDM,

     Try deleting in this order now:

-- delete history of the project
delete from EPUB_PR_HISTORY where project_id in
(select project_id from epub_project where project_id = '?');

-- delete the project
delete from epub_project where project_id = '?';

-- delete history of the process
delete from EPUB_PROC_HISTORY where process_id in
(select process_id from epub_process where project = '?');

-- delete task information of process
delete from EPUB_PROC_TASKINFO where id in
(select process_id from epub_process where project = '?');

-- delete states of project (if any)
delete  from EPUB_IND_WORKFLOW where process_id in
(select process_id from epub_process where project = '?');

-- finally delete the process
delete from epub_process where where project = '?';

commit;

Let me know, even try loggingDebug true for DeploymentServer, DeploymentAgent, DeploymentManager?

[Kadinamkulam]

ya Rajinder,

Update : - WIP

I made some delete from DB and now in BCC I am unable to LOG-IN.

I can see the BCC  login page, but cannot login in.
Nothing is getting written to the logs. But can access dyn/admin.


Any thoughts ?


Warm Regards
KdM

[Rajinder S. Nagi]

my understanding, you deleted tables now again, did u invalidate
publishingrepository again?

On 9/26/12, Kadinamkulam <kadina...@gmail.com> wrote:
> ya Rajinder,
>
> Update : - WIP
>
> I made some delete from DB and now in BCC I am unable to LOG-IN.
>
> I can see the BCC login page, but cannot login in.
> Nothing is getting written to the logs. But can access dyn/admin.
>
>
> Any thoughts ?
>
>
> Warm Regards
> KdM
>
>
> On Wed, Sep 26, 2012 at 1:13 PM, Rajinder S. Nagi
> <raj.h...@gmail.com>wrote:
>
>> KDM,
>>
>> Try deleting in this order now:

>> *-- delete history of the project

>> delete from EPUB_PR_HISTORY where project_id in
>> (select project_id from epub_project where project_id = '?');
>>
>> -- delete the project
>> delete from epub_project where project_id = '?';
>>
>> -- delete history of the process
>> delete from EPUB_PROC_HISTORY where process_id in
>> (select process_id from epub_process where project = '?');
>>
>> -- delete task information of process
>> delete from EPUB_PROC_TASKINFO where id in
>> (select process_id from epub_process where project = '?');
>>
>> -- delete states of project (if any)
>> delete from EPUB_IND_WORKFLOW where process_id in
>> (select process_id from epub_process where project = '?');
>>
>> -- finally delete the process
>> delete from epub_process where where project = '?';
>>

>> commit;*

>>>> 1) *- Removing locks of the project if any

>>>> delete from avm_asset_lock where workspace_id in
>>>> (select id from avm_devline where name in

>>>> (select workspace from epub_project where project_id = '?'))*
>>>> *
>>>> *
>>>> *Invalidate below repository caches
>>>> /atg/epub/version/VersionManagerRepository/*
>>>> *
>>>> *
>>>> *Hope you already invalidated:*
>>>> */atg/epub/PublishingRepository/*
>>>> *
>>>> *Best Regards,

>>>>>> I *committed *after executing the procedure.
>>>>>>
>>>>>> *Invalidated *the repository cache..

>>>>>> /dyn/admin/nucleus/atg/epub/PublishingRepository/
>>>>>>
>>>>>> All worked and the project got removed from BCC .. :)
>>>>>>
>>>>>> Warm Regards
>>>>>> KdM
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Thu, Aug 30, 2012 at 1:49 PM, Gordon Cooke
>>>>>> <gor...@sparkred.com>wrote:
>>>>>>
>>>>>>> Did you commit the transaction after running the proc?
>>>>>>>
>>>>>>> This should remove all the relevant data from the system.
>>>>>>>
>>>>>>> Gordon Cooke
>>>>>>> Spark::red - Managed ATG Hosting
>>>>>>> http://sparkred.com
>>>>>>> gor...@sparkred.com
>>>>>>> m: 206-384-1314
>>>>>>> w: 888-666-5582
>>>>>>>
>>>>>>> Follow Spark::red for the latest news on eCommerce and ATG:
>>>>>>>
>>>>>>> Twitter - www.twitter.com/ATGhostingSpark
>>>>>>> Facebook - www.facebook.com/SparkredATGHosting
>>>>>>> Blog - www.sparkred.com/blog/
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Aug 30, 2012, at 11:07 AM, Kadinamkulam <kadina...@gmail.com>
>>>>>>> wrote:
>>>>>>>
>>>>>>> Hi Gordon,
>>>>>>>
>>>>>>> I executed this procedure and the data is removed from the db and

>>>>>>> *restarted
>>>>>>> the CA instance.*

>>>>>>>
>>>>>>> But still I can see those projects in BCC. is there any thing else

>>>>>>> we need to check.. like is there any *lock *or so ?

>>>>>>>> * *
>>>>>>>>
>>>>>>>> *COUNT(*)*
>>>>>>>>
>>>>>>>> *WORKSPACE_ID*
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> *0*
>>>>>>>>
>>>>>>>> 6
>>>>>>>>
>>>>>>>> 45785
>>>>>>>>
>>>>>>>> *1*
>>>>>>>>
>>>>>>>> 4
>>>>>>>>
>>>>>>>> 47682
>>>>>>>>
>>>>>>>> *2*
>>>>>>>>
>>>>>>>> 2
>>>>>>>>
>>>>>>>> 50564
>>>>>>>>
>>>>>>>> *3*
>>>>>>>>
>>>>>>>> 7
>>>>>>>>
>>>>>>>> 52051
>>>>>>>>
>>>>>>>>
>>>>>>>> /
>>>>>>>> <http://stgs4041:30281/dyn/admin/nucleus/>atg/<http://stgs4041:30281/dyn/admin/nucleus/atg/>
>>>>>>>> epub/ <http://stgs4041:30281/dyn/admin/nucleus/atg/epub/>
>>>>>>>> PublishingRepository/<http://stgs4041:30281/dyn/admin/nucleus/atg/epub/PublishingRepository/>

[Kadinamkulam]

yes, even restarted ...

[Rajinder S. Nagi]

Which version and which username and password you are using?

[Rajinder S. Nagi]

Even did u see any error once you started the instance? 

There is nothing you should not be able to login?

[Kadinamkulam]

In the startup logs i can see only this error

2012-09-26 14:47:10,632 ERROR [DeploymentServer] Attempt to recover deployment '36900002' failed because the matching current deployment could not be found in the database.  Complete Status :  file = /data/atg/jboss-eap-4.3/jboss-as/server/dev-jboss-project-ca/ATG-Data/servers/dev-jboss-project-ca/Publishing/deployment/data/dep-stat-1348682747253 : target = Production : deployedSnapshot = null : deployedSnapshotTimestamp = 1347974031065 : state = 902 : stateString = DONE_STOP : stateTimestamp = 1348682747251 : previousState = 901 : errorMessage = null : deploymentID = 36900002 : deploymentBeginTimestamp = 1348504350306 : deploymentLastBeginTimestamp = 1348682658224 : deploymentLastExecutionTime = 14 : deploymentTotalExecutionTime = 3641 : deploymentProjectIDs = [Ljava.lang.String;@4038e6d8 : deploymentToSnapshot = null : deploymentFromSnapshot = null : deploymentType = 2 : deploymentMode = 11 : deploymentRevert = false : deploymentServer = projectvm1:10250 : deploymentCreateInitiator = anilal : deploymentStopInitiator = anilal : deploymentDeleteInitiator = null : deploymentManifestID = null : deploymentCommitted = false : deploymentSwitched = false : deploymentRollback = false : deploymentRollbackInitiator = null : deploymentRollbackManifestID = null

[Rajinder S. Nagi]

Did you delete any deployment before?

[Kadinamkulam]

yes .. i deleted ALL the records the  epub_deployment and avm_asset_lock tables.

[Rajinder S. Nagi]

It is more messy, as we try to resolve deployments at the CA level not at databases.

do you have any data in epub_deploy_proj and epub_dep_log?

[Kadinamkulam]

Yes Rajinder :

select count(*) from epub_deploy_proj ;
select count(*) from  epub_dep_log

COUNT(*)              
----------------------
7                     

1 rows selected

COUNT(*)              
----------------------
11851                 

1 rows selected

[Rajinder S. Nagi]

Can you find the deployment id which points to the current deployment and clear it.

[Kadinamkulam]

select * from epub_deploy_proj where  deployment_id like '%36900002'

DEPLOYMENT_ID                            PROJECT_ID                               SEQUENCE_NUM          
---------------------------------------- ---------------------------------------- ----------------------
36900002                                 prj379002                                0                     

1 rows selected


you mean, now delete from epub_deploymetn table for 36900002                                 ??


Warm Regards
KdM

[Rajinder S. Nagi]

first what data you have in epub_deployment?

[Kadinamkulam]

zero Rows,  Rajinder ..

[Rajinder S. Nagi]

Once you delected all the projects before, how this project wtih deployment id is showing in epub_deploy_proj , delete this record and restart the instance. please set loggingDebug for deploymentManager, DeploymentServer and DeploymentAgent before restarting the instance. You can set the configured value in ACC to true for loggingDebug property on these components, so that you can see console issues once you restarting the instance.

[Kadinamkulam]

Yes, Now I am able to login to BCC. Thanks a lot Rajinder for your speedy help,

Warm  Regards
KdM