Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
When doing schema script generator, if <all schemas> is selected as the schema then the extraction of the synonym list is incorrectly using 'null' as the schema. This affects all oracle versions... this is probably reproducible in previous versions of data studio.
|
4 KB
@sachin : this is easy to fix by just not including the schema condition in the extraction query when the schema is configured to null. Waiting on priority setting to critical to check in fix. This fix affects all versions of oracle and is currently broken in older versions of ads.
I have attached a patch file for the extraction class fix.
I have attached a patch file for the extraction class fix.
@ QA team: We need to do a regression test against all databases for schema script generator to make sure that when we choose <all schemas> the extraction of all the objects is correctly returning the list. So easiest way to to do a database at a time and a single object type at a time. Create multiple objects of that object type in different schemas and make sure that when you select the individual schema the objects are correctly listed and then when you choose <all schemas> we see all the objects.
I ran into this issue by chance on oracle synonyms but its very possible that this could be the case for other object types.
I am not sure the qa process but some process to make sure this is working needs to be put into place.
@ QA team: We need to do a regression test against all databases for schema script generator to make sure that when we choose <all schemas> the extraction of all the objects is correctly returning the list. So easiest way to to do a database at a time and a single object type at a time. Create multiple objects of that object type in different schemas and make sure that when you select the individual schema the objects are correctly listed and then when you choose <all schemas> we see all the objects.
I ran into this issue by chance on oracle synonyms but its very possible that this could be the case for other object types.
I am not sure the qa process but some process to make sure this is working needs to be put into place.
@ivan: go ahead & check-in to US Trunk & then delete the patch file.
@ivan: go ahead & check-in to US Trunk & then delete the patch file.
Extraction modified so that if schema is null it will no longer check that the object schema is null but instead select all objects regardless of schema.
Committed revision: 53002
Extraction modified so that if schema is null it will no longer check that the object schema is null but instead select all objects regardless of schema.
Committed revision: 53002
We have extended the test area by performing the requested tests on Schema script generator by selecting <All Schemas> for following DBs:
Amazon EMR- hive ----- Pass
We have extended the test area by performing the requested tests on Schema script generator by selecting <All Schemas> for following DBs:
Amazon EMR- hive ----- Pass
DB2 z/OS 10 & 11 -- Pass
I have fixed the SAP Hana index extraction so that it correctly extracts all schema indexes when schema is configured to null value.
Committed revision: 53016
DB2 z/OS 10 & 11 -- Pass
I have fixed the SAP Hana index extraction so that it correctly extracts all schema indexes when schema is configured to null value.
Committed revision: 53016
@ Ajinkya
Can you please look into this issue if its working fine then marked as closed.
@ Ajinkya
Can you please look into this issue if its working fine then marked as closed.
DB2 z/OS 11 -- Pass
-- All objects are being extracted correctly when <All Schemas> is selected in schema script script generator. Scripting is working fine.
-- Apart from this, verified server script generator and is too working fine.
SAP Hana -- Pass
-- All objects are being extracted correctly when <All Schemas> is selected in schema script script generator. Scripting is working fine.
DB2 z/OS 11 -- Pass
-- All objects are being extracted correctly when <All Schemas> is selected in schema script script generator. Scripting is working fine.
-- Apart from this, verified server script generator and is too working fine.
SAP Hana -- Pass
-- All objects are being extracted correctly when <All Schemas> is selected in schema script script generator. Scripting is working fine.
Issue #14991 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build v18.0.0-preview-88 |
| No time estimate |
@sachin : this is easy to fix by just not including the schema condition in the extraction query when the schema is configured to null. Waiting on priority setting to critical to check in fix. This fix affects all versions of oracle and is currently broken in older versions of ads.