We found the issue...
The ownership was changed during the restore, however the object authorities for the directories did not.
In the case below, GWILBURN is the owner... on the new box the object authorities were missing.
Old box:
Type options, press Enter.
1=Add user 2=Change user authority 4=Remove user
Data --Object Authorities--
Opt User Authority Exist Mgt Alter Ref
*PUBLIC *RWX X X X X
GWILBURN *RWX X X X X
QDIRSRV *X
New box
Type options, press Enter.
1=Add user 2=Change user authority 4=Remove user
Data --Object Authorities--
Opt User Authority Exist Mgt Alter Ref
*PUBLIC *RWX X X X X
GWILBURN *RWX
QDIRSRV *X
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Steinmetz, Paul via RPG400-L
Sent: Monday, April 12, 2021 2:00 PM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Cc: Steinmetz, Paul <PSteinmetz@xxxxxxxxxx>
Subject: RE: HSSFCGI issue after migration
If not a system default, did your RSTAUT on you migration complete with no issues.
Do you still have access to the previous system, compare authorities on the impacted items.
-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Greg Wilburn
Sent: Monday, April 12, 2021 1:56 PM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: HSSFCGI issue after migration
Power7+ to Power9.
Both on v7r3
What system default value would cause that? We are having permissions issues with other IFS folders.
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Steinmetz, Paul via RPG400-L
Sent: Monday, April 12, 2021 11:46 AM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Cc: Steinmetz, Paul <PSteinmetz@xxxxxxxxxx>
Subject: RE: HSSFCGI issue after migration
From what machine to what machine.
From what os level to what os level
Possibly a system default value is different.
Paul
-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Greg Wilburn
Sent: Monday, April 12, 2021 11:38 AM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: HSSFCGI issue after migration
We migrated to a new system over the weekend. I use HSSFCGI and XLSXGEN to create a lot of reports on the IFS.
When I run a job it's fine. When my users run the same job it creates a weird temp file and doesn't create the XLSX file.
In debug, WrtHtmlToStmf() returns a 3025
Instead of <myfilename>.tmp, I see <myfilename>.tmpTEMP123456 (where 123456 is the job number).
I checked the authorities on the HSSFCGI library as well as the IFS directories. All looks good.
Any ideas?
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
As an Amazon Associate we earn from qualifying purchases.