[
https://issues.apache.org/jira/browse/ISIS-766?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14107136#comment-14107136
]
Dan Haywood commented on ISIS-766:
----------------------------------
Ran in the attached script with no errors:
$ psql -U postgres -d ods_master_bby < /c/users/dan/downloads/Postgresql_Audit_
trigger_91plus.sql
NOTICE: extension "hstore" already exists, skipping
CREATE EXTENSION
SET
NOTICE: CREATE TABLE will create implicit sequence
"audit_logged_actions_event_id_seq1" for serial column
"audit_logged_actions.event_id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"audit_logged_actions_pkey" for table "audit_logged_actions"
CREATE TABLE
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
when attempt the upload, get a permissions error:
18:30:22,305 [Persist 1021948079@qtp-923461372-3 ERROR] Update
of object "com.wipro.wess.ods.asset.OmAsset@2e5cb1da" using statement "UPDATE
gemsods."om_asset" SET "changedate"=?,"location_uid"=?,"loc_org_id"=? WHERE
"asset_uid"=? AND "org_id"=?" failed : org.postgresql.util.PSQLException:
ERROR: permission denied for relation audit_logged_actions
Where: SQL statement "INSERT INTO gemsods.audit_logged_actions VALUES
(gemsods_row.*)"
PL/pgSQL function audit_ods_master_changes_func() line 65 at SQL statement
> ISIS Service / ViewModel method calling twice when this method processing
> BLOB type
> -----------------------------------------------------------------------------------
>
> Key: ISIS-766
> URL: https://issues.apache.org/jira/browse/ISIS-766
> Project: Isis
> Issue Type: Bug
> Components: Viewer: Wicket
> Affects Versions: viewer-wicket-1.4.1
> Reporter: Ranganath Chittari
> Assignee: Dan Haywood
> Priority: Blocker
> Fix For: viewer-wicket-1.7.0
>
> Attachments: BBY Provisioning Template V1 12.3.xlsx,
> Behaviour-Rejected-Error.log, Files.zip, Postgresql_Audit_trigger_91plus.sql,
> Upload-Invocation-Failed.log, dom.zip
>
>
> Isis service or ViewModel method getting called twice.
> For ex:
> I have one Hidden service which has lookup method with @HomePage returning a
> ViewModel instance using newViewModelInstance(..) method and that renders one
> action method taking Blob parameter as button. It's basically upload button
> to upload a file. When I click on upload button, this upload method called
> and completed the uploading and again getting called second time by itself.
> And this is inconsistent behavior. Some times its working(meaning called only
> once) but some other times it's not.
> So I tried this upload action with service class by extending AbstractService
> which appears in the menu with Upload action. Here also it's the same issue.
> Please find attached files in this Jira as I don't have GIT client to push
> the files in github
> BR
> Ranganath Varma
--
This message was sent by Atlassian JIRA
(v6.2#6252)
