Social Icons

viernes, 30 de septiembre de 2016

DSDQ - Unable to adquire license for any feature

Para la instalación de esta aplicaron se presentaron problemas, asi que se tubo que copiar la carpeta instalada en un equipo que si funciona en el equipo nuevo y la aplicación se abrió sin problemas.

En caso de presentarse el siguiente error
Una de las causas debe ser que el numero de licencias disponibles ya estan en uso

jueves, 29 de septiembre de 2016

DEPURACIÓN DE USUARIOS EN EDM




Anexos
SQL paso 5
SELECT * FROM MD_SITE_USER WHERE IS_DISABLED='N' AND USER_NAME NOT LIKE 'EDM%' 
AND USER_NAME NOT LIKE 'TOW%' AND USER_NAME NOT LIKE 'USR%' AND USER_NAME NOT LIKE 'tow%'
AND USER_NAME NOT LIKE 'usr%' AND USER_NAME NOT LIKE 'use%'
AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'DSS'
AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'autosync'
AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'COREADMIN'
AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'OWGER'
AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'QETOW_BATCH'
AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'DSSQUERY'
AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'DWEDM'
AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'towrep'
AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'USE%'
AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'OWREP'
ORDER BY USER_NAME_FULL

SQL paso 6
UPDATE (SELECT * FROM MD_SITE_USER WHERE IS_DISABLED='N' AND USER_NAME NOT LIKE 'EDM%'
AND USER_NAME NOT LIKE 'TOW%' AND USER_NAME NOT LIKE 'USR%' AND USER_NAME NOT LIKE 'TOW%'
AND USER_NAME NOT LIKE 'usr%' AND USER_NAME NOT LIKE 'use%'
AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'DSS'
AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'autosync'
AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'COREADMIN'
AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'OWGER'
AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'QETOW_BATCH'
AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'DSSQUERY'
AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'DWEDM'
AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'towrep'
AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'USE%'
AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'OWREP'
AND USER_NAME NOT LIKE 'edm%' AND USER_NAME NOT LIKE 'GUEST')
set IS_DISABLED='Y'

SQL paso 8
MERGE into MD_SITE_USER t1
using (SELECT * FROM USUARIOS_AD) t2
on (UPPER(t1.USER_NAME)=UPPER(t2.CUENTA))
when matched then update set t1.is_disabled='N'

martes, 27 de septiembre de 2016

45YYYA34

L E G I S L A C I Ó N    M E R  C A N T I L   Y
S   O   C   I   E   T  A R I A


Descargar cliente de Oracle 19c

  Oracle Database 19c Download for Microsoft Windows x64 (64-bit) https://www.oracle.com/database/technologies/oracle19c-windows-downloads.html

 
 
Blogger Templates