OAS 7.6.0.0.241001 Semantic Modeler opening model errors

user6091159

Hello,

I'd be glad if you could advise with the following errors.

1. After editing and saving semantic models, sooner or later, opening is not possible with the following error:

Your request to load the Semantic Model could not be processed. Unexpected response status: 500

If it's a deployed model, the reports based on the model still work. If we duplicate the model, we get the same error.

Relevant log entries:

[2024-10-06T07:30:07.488-07:00] [bi_server1] [ERROR] [] [oracle.bi.semanticmodeler.dss.extension.api.v6.SemanticModelWorkspaceResource] [tid: [ACTIVE].ExecuteThread: '36' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 83df8b1c-e956-4817-9c85-da5d258e1c68-00000c74,0:7] [APP: bidatasetsvc] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SI-Key: ssi] Failed to retrieve zip file[[
oracle.bi.web.datasetsvc.objectstorage.v2.exception.ObjectStorageException: Object not found
at oracle.bi.web.datasetsvc.objectstorage.v2.api.FileStorageClient.assertObjectExists(FileStorageClient.java:152)

…

[2024-10-06T07:30:07.493-07:00] [bi_server1] [ERROR] [] [oracle.bi.semanticmodeler.api.BaseResource] [tid: [ACTIVE].ExecuteThread: '21' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 83df8b1c-e956-4817-9c85-da5d258e1c68-00000c74,0] [APP: bitech-analysis-application] [partition-name: DOMAIN] [tenant-name: GLOBAL] [DSID: 0000P9YF4DmFg405zzP5iW1b0dCC000007] [SI-Key: ssi] Unexpected response status: 500[[

oracle.bi.semanticmodeler.service.workspace.WorkspaceServiceException: Unexpected response status: 500
at oracle.bi.semanticmodeler.service.workspace.DSSWorkspaceService.loadWorkspace(DSSWorkspaceService.java:680)
at oracle.bi.semanticmodeler.api.v1.SemanticModelResource.loadWorkspace(SemanticModelResource.java:461)…

2. After applying the latest patch set (37123210) we have an other related? problem.

If we create a new model, save it, close and try to open it, the new model wizard appears. Choosing the empty model we get a blank model, but the objects are there somewher (they're not visible), because we're not able to create objects with the same name.

We tried: cleaning cache, different browsers, full restart, different permissions and languages, changing all the (perhaps) related settings.

Thank you for your help,

Attila

BalagurunathanBagavathy-Oracle

@user6091159 I would suggest you to log a SR for this issue.

Joel

@user6091159, did you do a check consistency test? Are you able to convert the model to a binary rpd file and open in the admin tool? It's also well worth opening an SR for this in parallel.

user6091159

Thank you for the answers.

Regarding to the first problem. I'm not able to open them. It can happen with any model. Therefore I'm not able to export them or do a consistency check. Command line tools, like downloadrpd, works on the deployed model. Anyway these models were went through consistency check, there are reports based on them and sometimes they were already deployed some time before.

The second problem happens with every model. Even with the simplest. I create a empty model in Semantic Modeler, do something simple change, e.g. change the database name, save it and close it. When I try to open it, create model wizard appear. When I click empty model it opens as empty, but I'm not able to add another database with same name (name is already used). Because this patch released only a few days ago, we'll try to rollback it.

Joel

In that case, an SR might be the best line of action as there seems to be something fundamentally wrong in your environment.

Gianni Ceresa

While the SR is the way to go (they will need a number of details that you can't share on a public forum), the semantic models are stored on disk, if they exist. Not saying that this is the way to do things, but it could help you in recovering or have a backup of your models that you could then import somewhere else, or even just to have something to copy if you have to rebuild something.

Each semantic model is stored in a single file, which happen to be a zip (but isn't named as such).

By default in OAS 2024 (7.6) they are stored in <domain>/bidata/components/DSS/storage/ssi there you should find 2 files for each semantic model, one without extension (this is the zip), the other with the same filename with a .metaextension. The file names should start with 2F64762F73656D616E7469636D6F64656C732F776F726B7370616365732F and continue with a bunch more characters (that prefix in the name has a meaning, that's why it should be the same: I only checked on a single OAS 2024, but I'm quite optimistic).

If you read the .meta it should contain "contentType":"application/zip"confirming the file is a ZIP, then you can just copy the file without extension on your PC and extract it as a ZIP. You will not be able to do much with it, but if you keep extracting it (in my case the ZIP contains another file with is also a ZIP, didn't check if it's a double zipping or some other form or archive), you get to the SMML files (the json defining Semantic Models).

As said: this isn't meant to be a solution, just a way to get your semantic models back in case you need them while you wait for the SR to work on your case. As far as I know it isn't supported or documented, but let's say it does the job… (or maybe let the admin of that server handle that part if you don't feel like doing these things).

user6091159

Dear Gianni,

thank you for your suggestions. I've checked the folder you mentioned and the bad news is I've found files for each of the working models, but haven't found any files for the erroneous models. So the reason is that the files somehow got lost. Both meta and the zip. And there is no good news.

You're right, these are double zipped files and the model files are accessbile through them.

The problem might be related to the clumsy handling of long filenames in Windows. It's a Windows Server 2016 and I was not able to extract and rename the files with the standard Windows explorer tools.

Gianni Ceresa

That's no luck…

Then it sounds like there is a mismatch between the database and the disk.

If you look in the BIPLATFORM schema, in the SEMANTIC_MODEL_WORKSPACE table, you will find your ghost semantic model. But if the files do not exist on disk, it will never be able to open it.

As for the reason of how you ended up in this situation with a mismatch between database and disk, that's what the SR will be for. And hopefully, if it's a reproductible bug, they will be able to release a patch.

user738937-Oracle

Is this a windows 16 specific issue? Can you try to enable long path name settings (LongPathsEnabled) and see if that helps?

user6091159

Some follow up. Long path names was already active, so it was not the cause.
We reinstalled the infrastructure on Windows 2019 Standard, with as many change during the installation, as we can, but we faced the same issue.
After investigating more, we found that the semantic modeler was not able to save the models. We found this error in bi_server1-diagnostic.log. I think, this is the most relevant entry:

java.util.concurrent.ExecutionException: java.lang.NoSuchMethodError: org.apache.commons.compress.archivers.tar.TarArchiveOutputStream.putArchiveEntry(Lorg/apache/commons/compress/archivers/tar/TarArchiveEntry;)

[2024-10-14T23:46:04.213-07:00] [bi_server1] [ERROR] [] [oracle.bi.semanticmodeler.service.workspace.UploadManager] [tid: [ACTIVE].ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 598a5eff-ca41-42aa-84b5-c52985437aa9-0000a49f,0] [APP: bitech-analysis-application] [partition-name: DOMAIN] [tenant-name: GLOBAL] [DSID: 0000PAEukFpFO905zzx0iW1b3Mr0000005] [SI-Key: ssi] Failed to upload newly created workspace e6394571-db11-41db-8ddb-6a2bd9d7ad3f with lock key null
[2024-10-14T23:46:04.215-07:00] [bi_server1] [ERROR] [] [oracle.bi.semanticmodeler.api.BaseResource] [tid: [ACTIVE].ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 598a5eff-ca41-42aa-84b5-c52985437aa9-0000a49f,0] [APP: bitech-analysis-application] [partition-name: DOMAIN] [tenant-name: GLOBAL] [DSID: 0000PAEukFpFO905zzx0iW1b3Mr0000005] [SI-Key: ssi] java.util.concurrent.ExecutionException: java.lang.NoSuchMethodError: org.apache.commons.compress.archivers.tar.TarArchiveOutputStream.putArchiveEntry(Lorg/apache/commons/compress/archivers/tar/TarArchiveEntry;)V[[
oracle.bi.semanticmodeler.service.workspace.WorkspaceServiceException: java.util.concurrent.ExecutionException: java.lang.NoSuchMethodError: org.apache.commons.compress.archivers.tar.TarArchiveOutputStream.putArchiveEntry(Lorg/apache/commons/compress/archivers/tar/TarArchiveEntry;)V
at oracle.bi.semanticmodeler.service.workspace.DSSUploadManager.upload(DSSUploadManager.java:179)
at oracle.bi.semanticmodeler.service.workspace.DSSWorkspaceService.uploadWorkspace(DSSWorkspaceService.java:342)
at oracle.bi.semanticmodeler.service.workspace.DSSWorkspaceService.createWorkspace(DSSWorkspaceService.java:489)
at oracle.bi.semanticmodeler.api.v1.SemanticModelResource.createWorkspace(SemanticModelResource.java:332)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)

user738937-Oracle

Thanks for the stack trace. Investigating.